Respected MVPs, experts and gurus,
I have written the following code to calculate the % out of total for all the rows. I am sure there is a better way to do it.
I wrote this code as I cannot make the denominator fixed. For 2,000 rows it is not a big deal but some sheets have 100,000 rows which might take significant time to execute this loop. Instead of this loop, copying the formula from third row and pasting it from fourth row to lastrow3 (fixed with "$" sign) should be the simple way to execute the code quickly.Please Login or Register to view this content.
I have thought the following code but could not fathom "..................." :
The Total is at lastrow3 plus one cell down.Please Login or Register to view this content.
Thank you
Roshan Shakya
Bookmarks