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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.