Tim in Toronto
New Member
- Joined
- Nov 18, 2004
- Messages
- 47
Hi Everyone,
I'm having a hard time figuring out a simple thing. Maybe I'm over thinking it. I simply want the macro to see if the word "FALSE" exists in column I, and if so then delete the column. Failing that, I just want it to return to cell A1. Tain't working. Any ideas on what I'm doing wrong here?
Range("I1").Select
If ActiveCell.Value = "FALSE" Then
Columns("I:I").Select
Selection.Delete Shift:=xlToLeft
Else
Range("A1").Select
End If
Tim
I'm having a hard time figuring out a simple thing. Maybe I'm over thinking it. I simply want the macro to see if the word "FALSE" exists in column I, and if so then delete the column. Failing that, I just want it to return to cell A1. Tain't working. Any ideas on what I'm doing wrong here?
Range("I1").Select
If ActiveCell.Value = "FALSE" Then
Columns("I:I").Select
Selection.Delete Shift:=xlToLeft
Else
Range("A1").Select
End If
Tim