My question is: Im working with named ranges in a large workbook. I need to copy data say from some named range in some worksheet x and paste it on another named range say wksheet y before i can sort it and display it on yet another range in wksheet z.
I have achieved all this through vba except for screen flickers alot when i execute the code.
Im using the statement application.goto reference:="" to select the ranges and this activates these sheets hence the flickering back n forth. which dosent look appealing.
Is there a way i could work with the sheets without activating them.
Thank you.
No comments:
Post a Comment