Excel VBA Count # of Cells within Max and Min in a Table
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

Excell VB
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

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.
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

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