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

Ojbect required error msg
 

Chet,

Change

If Worksheet.Function.IsText(Target) Then
to
If Application.WorksheetFunction.IsText(Target) Then


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Chet Shannon" <Chet wrote in
message
...
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