T
The Inspector
I need to know what text is in an cell. The cell will be used to determine
what sheet will be edited with the macro.
what sheet will be edited with the macro.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do I, in VBA, test to see if a cell has a specific word in it
D
Don Guillett
A bit more info
B
Brad
Sub SelectSheet()
If ActiveCell.Value = MyValue Then
Sheets("MyValue").Select
Else
Sheets("NotMyValue").Select
End If
End Sub
Hope this helps.
If ActiveCell.Value = MyValue Then
Sheets("MyValue").Select
Else
Sheets("NotMyValue").Select
End If
End Sub
Hope this helps.
P
Patrick Molloy
do you mean
If ActiveCell.Value = "MyValue" Then
otherwise MyValue becomes a variable, defaulting to null and the IF
condition will always be False
If ActiveCell.Value = "MyValue" Then
otherwise MyValue becomes a variable, defaulting to null and the IF
condition will always be False
T
The Inspector
Thanks guys
Patrick Molloy said:do you mean
If ActiveCell.Value = "MyValue" Then
otherwise MyValue becomes a variable, defaulting to null and the IF
condition will always be False