Code not allowing to view progress

[F6Hawk]

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.

[mudraker]

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

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.