Hello,
I've tried my best to search, but cannot find anything concrete.
I'm using Excel 2013 and I've programmed some automation into Visual Basic. It's fairly simple stuff, such as copying and pasting data from one sheet to another, etc.
Unfortunately, what is happening is after the macro runs, the worksheet I end up on (the data has pasted just fine), but when using the scroll button on my mouse or the arrows on my keyboard, the worksheet itself does not respond. I can see the scroll bar at the right going up and down as I either use the scroll button on the mouse or the arrow keys, but again, the worksheet does not respond. This is not a freeze panes issue, the destination worksheet does not have frozen panes.
In the little bit I was able to find on the internet from folks with similar issues is that it appears as though (through my own testing as well) the original worksheet (where the data was copied from), that worksheet is actually the one that is being scrolled through. So, it's very strange, but the scrolling ability seems to not come along after the code has completed what it's supposed to do.
Another thing, I have removed all of the Application.ScreenUpdating True/False as I thought maybe I was forgetting to put it back once I took it off. So I completely took all of any code based screen updating out.
Another key piece of information. If I am to go to another worksheet in the workbook and then BACK to where the data was copied to (where the code ended), I am then able to scroll again.... and everything works like it should. However if I program the worksheet changes to happen, so from the destination sheet to another sheet and then back to the destination sheet, it still does not work.
I'm at a loss. I hope there is someone out there who has had the same problem and has been able to find a solution.
Thanks in advance for anyone who is able to point me in the right direction.
Bookmarks