I have some code that works great as long as you run it from the sheet that it references, copying certain data to an output sheet. But I would like to be able to step thru it while viewing the output sheet, mostly for troubleshooting. How can I change the code to reference the proper INPUT (Sort Page) sheet while watching the results on the OUTPUT (2-2 Forecast) sheet using F8 to watch it progress?
TIA,
Hawk
Please Login or Register to view this content.
There is only 1 line of code that does not mention which sheet it is refering to so I will assume that is what you are refering to.
replace
withPlease Login or Register to view this content.
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks