Run-time error 91 when using Range.Find | ONLY SOMETIMES

[sxj]

I created a macro that is meant to detect the first cell in a specific range that DOES NOT have a border, before performing other tasks based on that information.

This is the first part of my code:

Please Login or Register  to view this content.

When I open the macro file BEFORE the data file on which it is run, everything usually works fine.
If I open the macro file AFTER the data file and try to run it, I receive this error message:
"run-time error '91' Object variable or With block variable not set"

The debugger highlights this section of the code:

Please Login or Register  to view this content.

Any idea why this works sometimes and not others?

[Leith Ross]

Hello sxj,

Is this macro in your Personal.xlsm file?

[sxj]

Hi Leith,

I'm not sure what a personal.xlsm file is (so I'm guessing the answer is no). All the macros I use are local though, individual workbooks saved to my desktop.