For some reason, a certain part of my Rename Sheet macro keeps getting a "Compile Error". This is inconsistent - the macro works perfectly on my laptop but not on others.
Here's a screenshot of the error. (The "Left$" is where we're having the issue)
Macro Error.jpg
Can anyone figure out why? Any help is appreciated!!
Bookmarks