Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-06-2014, 05:23 PM
wxtoad wxtoad is offline Macros are VERY slow to run Windows 7 64bit Macros are VERY slow to run Office 2013
Novice
Macros are VERY slow to run
 
Join Date: Sep 2014
Posts: 6
wxtoad is on a distinguished road
Default Macros are VERY slow to run

I think it's because when each function is executed, it goes all the way down to bottom of the spreadsheet, well beyond the last row data. When I look at the sheet after executing a function, it has placed a "0" in all cells in the column below the data. Then when the next function executes, it goes all the way down to the bottom and attempts to do something with the "0"s.



My sheet contains only 27,000 rows. Is there some way to limit calculations to only those rows and no further into the blank portion of the sheet?
I record the macros - so far VBA is beyond my skill set.

Thanks,
WxToad
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook '07--snail slow markg2 Outlook 0 07-09-2014 09:42 AM
Macros are VERY slow to run Outlook slow? erik2282 Outlook 3 12-09-2011 03:15 PM
Macros are VERY slow to run Slow load? markg2 Word 1 03-15-2011 07:10 AM
Slow (delayed) keystrokes Jim Ogren Word 0 07-23-2009 07:47 PM
slow start kevb Office 1 08-15-2008 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft