Run Time Error 424

J

jfcby

Hello,

I'm getting a run time error 424: object required in this part of my
script:

If cell.Text = "001" Or Trim(Left(cell, 4).Offset(, 2).Text) = "BLDG"

How can it be modified so that it does not give the error.

Thank yo for your help,
jfcby
 
D

Dave Peterson

Maybe...

If cell.Text = "001" _
Or Trim(Left(cell.Offset(, 2).Text, 4)) = "BLDG" Then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-Time Error '424': Object required when Saving Document 6
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
variable problem error 424 1
Object Required Error 7
Method Range of Object Failed, Excel 2000 & 2003 7
Object Required Error, Excel 2000 & 2003 2
Error after code is run 4
Object required error 424 why getting? 2

Top