View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jfcby jfcby is offline
external usenet poster
 
Posts: 33
Default Run Time Error 424

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