PDA

View Full Version : run code if find anything in row 2 of column



Djblois
07-14-2006, 09:31 AM
I want to be able to run code if it finds anything in row 2 of column Q and different code if it is blank.

lucas
07-14-2006, 09:39 AM
If Range("O2").Value <> 0 Then Macro2 Else: Macro1

Djblois
07-14-2006, 09:48 AM
You know Lucas you are the man

lucas
07-14-2006, 10:04 AM
Further testing.....this should work a little better:

Option Explicit
Sub x()
If Range("O2").Value <> ("") Then
Macro1
Else: Macro2
End If
End Sub