I have a public function that divides the 1st cell in a range by the 2nd cell, rounds the value up, then divides to the 3rd and 4th cells and rounds up, then divides the 6th and 7th cells... until the end of the range.
Each rounded up value is added together and the function returns the total.
I'm looping through the range which I think is why it seems quite slow. Slow is a problem because I'm going to use this function in about 450 cells and each range will have up to 100 cells. Also, it really needs it to be a volatile function.
So I'm wondering if perhaps there is a better way to perform the required calculation. Perhaps manipulating the range via an array rather than a loop? But I'm not sure how to do that.
Any advice or suggestions would be appreciated.
Here's the existing code:
Please Login or Register to view this content.