Hi,
I am trying to make this code run quicker but am not very familiar with VBA. Any help is much appreciated. Thank you.
The code is taking a range from one worksheet and moving that range to another location but when I run this code over several thousand lines it takes forever. Is there any way to make it quicker? Thank you again for your help.
Please Login or Register to view this content.
Is there a reason it is a function rather than a sub?
I would propose (and the following assumes that your current calculation mode is set to automatic (Excel Options >> Formulas >> Calculation Options >> Advanced = True):
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks