Recorded macros run VERY slow

[wxtoad]

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

[protonLeah]

Post the code:

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

[wxtoad]

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[wxtoad]

Thanks, but that didn't help me much.