![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook '07--snail slow | markg2 | Outlook | 0 | 07-09-2014 09:42 AM |
![]() |
erik2282 | Outlook | 3 | 12-09-2011 03:15 PM |
![]() |
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 |