Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA IF QUESTION
I have this formula in vba:
If Range("C28") 0 Then Range("A23:D34").Select ActiveSheet.PageSetup.PrintArea = "$A$23:$D$34" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True It works fine and prints but it prints even if the cell is zero. What am I doing wrong. I only need it to print the range if c28 is greater than zero. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|