Copying from wb1 to wb2 throws subscript out of range error
My idea is to use FilePathToWb variable inside the Workbooks(FilePathToWb) argument to copy from ActiveWorkbook (sourceWb) to opened workbook (targetWb); close the sourceWb at the end so that I am left with targetWb only.
The debugger highlights the red font below.
Please Login or Register to view this content.
Last edited by immigrated4urjob; 12-22-2021 at 11:55 AM.
Where is targetWb variable defined?
targetWb as object
set targetWb=
subscript out of range error means the object( Worksheet) you are trying to access does not exist.
Last edited by AB33; 12-22-2021 at 11:45 AM.
Just typed, without test:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Weird bug. But I narrowed to one issue.Originally Posted by KOKOSEK
Essentially without activating SourceWb window the copy method was failing. I don't understand the why though, I just know this is the reason as I thought providing workbook name would suffice the copy operation.
So I needed to do before the copy line was add the following:
followed by rest of the code....Please Login or Register to view this content.
Thanks for the help.
It is becuase your workbooks, worksheets and ranges are not defined properly, see below where i have defined everything. It should work without needing to activate anything.
Please Login or Register to view this content.
Thanks, it helps me think about coding in a more refined way. I think at the end when I defined set with full reference, it worked fine without needing to activate workbook.It is becuase your workbooks, worksheets and ranges are not defined properly, see below where i have defined everything. It should work without needing to activate anything.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks