With the workbook name in B1 and worksheet name in B2 of active sheet. (I will have a second workbook and sheet in B3 and B4). I want to be able to choose those other workbooks so I can manipulate them. The workbooks will be open so don't need to worry about path.
Why doesn't this code work
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
May be
In the declare of WkSh1, you would declare as Worksheet not as collectionsPlease Login or Register to view this content.
And for assigning the worksheet, you would refer to the workbook
Hope this helps you
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Ahhhh, thanks. that works perfectly.
You're welcome. Glad I can offer some help
Thanks for the feedback and for the rep points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks