View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Shannon[_3_] Chet Shannon[_3_] is offline
external usenet poster
 
Posts: 1
Default Ojbect required error msg

I have some simple code. I am getting a msg saying "object required" on the
2nd line of my code. I am just trying to test if a cell has text in it or
not. What does the error mean so I can understand it. (I've gotten it before
but not understood what the problem meant.) And how can I fix it.

Target = Cells(Rowx, 19)
If Worksheet.Function.IsText(Target) Then
Cells(Rowx, 21) = 0
GoTo Jump1
End If

Thank you very much,
Chet Shannon