Greetings,
I'm writing some code that analises data and I have been adviced that it is good practice to minimise the function .Select in macros, especially when i'm just copying and pasting stuff. (as .select will make the screen jump from one sheet to the other and back etc.
but how do I minimise .Select in this example:Many thanks
Please Login or Register to view this content.
Michiel
Last edited by MichielEngineer; 11-10-2008 at 07:40 AM.
for example.Please Login or Register to view this content.
Great, Thanks romperstomper
at least this reduces the strobe effect my code was giving off.
Many thanks again.
Michiel
Glad to help. FYI, although it is much more efficient to remove all the unnecessary .Select statements, you can also use:
to remove screen flicker.Please Login or Register to view this content.
HTH
ha, thats a great tool, at least now I dont have to send a health warning to those who are going to use this tool.
Many Thanks
Michiel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks