Thread
:
VBA IF QUESTION
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
VBA IF QUESTION
Sub printif()
If Range("c28") 0 Then Range("a23:d34").Printout 'Preview
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Hamed parhizkar" wrote in
message ...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett