Hello,
Lately the reference to sheets does not work. In the code below the debug.print line gives me an error. Any ideas?
Thank you
Please Login or Register to view this content.
Hello,
Lately the reference to sheets does not work. In the code below the debug.print line gives me an error. Any ideas?
Thank you
Please Login or Register to view this content.
Last edited by katto01; 12-31-2019 at 09:39 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Your code works for me...
What issues are you having...What error...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi,
as sheet references always work if only the Logic is respected !
Here this error occurs when the active workbook is not the workbook containing the code …
Just better qualifying the workbook before the Sheets statement alone
as alone that means the active workbook
so not the workbook containing the code (aka ThisWorkbook) where exists the worksheet refered by its Sheet2 codename …
Last edited by Marc L; 12-31-2019 at 12:59 PM. Reason: typo …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks