On 2002-03-25 09:25, Todd_M wrote:
Hi-
If ActiveCell.Offset(0, 8).Value = Text Then
MsgBox "It works"
End If
Im trying to see if a cell located 8 cells to the left of a list has any text in it, and if it does to display a msgbox. My code does not work, any ideas??