(Solved) – Will it slow down my VBA subroutine if I make the sub call functions instead of having the commands directly in the subroutine?


I have one subroutine that does about 5 calculations with 8000 rows of data, stored in arrays. At the moment all the calculations are done directly in the sub. To make the code easier to navigate, I want to “outsource” each of the calculations to an individual function which the subroutine would call as it moves through the rows of data.

Before I go ahead and do this, I want to know if this will slow down my program significantly. I already have problems with speed, so I really don’t want to slow it down more.

If I did this, the sub would send the functions the address of each array element, so I wouldn’t be creating new variables.

Leave a Reply

Your email address will not be published. Required fields are marked *