Why does this fail with a subscript out of range error? The worksheet "January" exists.
Please Login or Register to view this content.
Why does this fail with a subscript out of range error? The worksheet "January" exists.
Please Login or Register to view this content.
I do not see any error with the line, and the error might be somewhere else in the code
I can take out all of the other code to leave just the following, and still get the error.
Please Login or Register to view this content.
There may be a space on Worksheets("January") name
Copy the sheet name from excel and paste it in to the code(Not manually)
Please Login or Register to view this content.
Yup - January had a trailing space.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks