Forum Discussion
Removing Screen flicker and adding efficiency to Copy Paste Macro
Hello smart excel users, I have a macro that I've made that pulls data from other reports. I typically get to use .range = .value2 because I use table 99% of the time, however, in the case of my ...
In the inserted file you will find the changes in the existing code that was attempted to adapt to your requirements.
Hope that it helps you😊
Niko! thanks! Looks like it works well. I have tested it in multiple scenarios. The only thing i am wondering is if there are any scenarios where it wouldnt be good to continue with opening the source book if it is already open. like if I am working on the source book and I go to upload into this report and it closes without saving and I lose data. Is it better to just close with saving or maybe if its already open have a pop up saying it is open and to close and try again??