How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?
Answer Question | November 25, 2010 3:24 AM
COUNTIF statement, Excel VB code, Excel VBA, Visual Basic
Woring on an excel 07 spread sheet. I would like a code that disables printing and saveing until all required cells are completed/filled out and clears the cells after printing. Any ideas
Answer Question | October 21, 2010 7:39 PM
Excel 2007, Excel VB code, Office 2007, Windows XP Pro SP3
Hi. I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell. i.e. the VB code should allow the “Cells.Find(What:=) to be VARIABLE based on what is pasted. Any suggestions?
Answer Question | June 30, 2010 1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code
I would like to know how can I create a VB code in excel for this task: I have two columns with day and tem values Day Temp 10.4 4.3 11.5 6.7 etc I want to select those day values that have a decimal 5 (10.5, 5.5, 3.5, etc) with its respective temp value Can [...]
Answer Question | March 18, 2010 6:22 PM
Excel VB code, VB