Thread: VBA IF QUESTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hamed parhizkar Hamed parhizkar is offline
external usenet poster
 
Posts: 45
Default 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.