Run-time error 91 - Object variable or with block variable not set

Hello - any idea on this error? Below is the code and this is where the error is occurring:

arr = Split(findit.Offset(0, 1), " ")

The code is supposed to open the latest modified file in the directory and loop through a column and copy names
to another column in the other file.

Thanks

Please Login or Register  to view this content.

You may have situations where findit is nothing because there was no match. Test if findit is set before Splitting.

Please Login or Register  to view this content.

Hello -

Yes findit was equal to Nothing.

Also, looking at it, I need it to do two things:

1) Chop off the first two characters
2) and search based on the first eight characters

Is that what its doing?

Thanks

Originally Posted by twckfa16

Hello -

Yes findit was equal to Nothing.

Also, looking at it, I need it to do two things:

1) Chop off the first two characters
2) and search based on the first eight characters

Is that what its doing?

Thanks

Set findit = Range("E:E").Find(what:=Mid(ce, 2,8))