Simple VBA question
Posted by Rob on July 09, 2001 7:11 PM
I have the following print button code:
Sub Credit_Discl_Print()
If Sheet16.Range("F2") = "" Then
With Sheet16.Range("A27:Z142").PrintOut
End With
Else
With Sheet16.Range("A27:Z257").PrintOut
End With
End If
End Sub
I would like to know if there is a way to test the VALUE of F2 to see if it is blank. Right now, I have a formula in it, and it is printing the first statement eventhough the value of F2 is blank. How do I fix this?
Thanks