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

(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 *