This workbook has about 10 sheets. the DCMR sheet is sheet 5(ish) and I want to have this macro pull from the 'visible' sheets to the right of it. How do I modify the code to do that?
Please Login or Register to view this content.
This workbook has about 10 sheets. the DCMR sheet is sheet 5(ish) and I want to have this macro pull from the 'visible' sheets to the right of it. How do I modify the code to do that?
Please Login or Register to view this content.
Does this help?
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 04-25-2017 at 11:39 AM.
Sorry, I am not following what that would do or how to use it. Do i replace some of my code with that?
I'm pretty sure John's code is to be used like this...Not sure, but the Do something part is where your code fits in.
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!!!
Thanks you again sintek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks