I know that when I use 'select' or 'activate' the screenupdating is set true. But I dont know how to change my code to fix this. At the very least, I'd like to not see the changes in the "Data" sheet. I know my code isnt the most efficient, but it works. Thank you!
- Luke
Please Login or Register to view this content.
You could try setting your worksheet to be an object, doyou don't need to activate your sheet, so for examplePlease Login or Register to view this content.
I haven't tested thatPlease Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Compile Error: Method or Data not found for wsData.Selection.Copy
Thank for trying.
Compile Error: Method or Data not found for wsData.Selection.Copy
Thank for trying.
selecting or activating does not turn screenupdating on
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you. That does work. I decided to delete the other bit of code regarding the red line, not worth the hassle. Now it doesn't flash to Data sheet. Enjoy the weekend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks