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:
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:
Any idea why this works sometimes and not others?
Bookmarks