Add SUM formula to each worksheet in the workbook for dynamic Column lengths...

Hi All,

I am currently trying to add a SUM formula for a dynamic range to the bottom of each column in each worksheet in the workbook except certain sheets. My code cycles through correctly however it is adding the SUM to the second row down, or to the row number of the first sheet total.

See Code:

Please Login or Register  to view this content.

I think this may be a simple solution but for the life of me i cant figure it out... Am i missing something right in front of me?

Move

Please Login or Register  to view this content.

to inside the loop like

Please Login or Register  to view this content.

Hi Jindon,

You've done it!! Thank you so much, I cant believe I never saw that. You taught us all something new.

Cheers!

If so many worksheets to skip, I would go with Select Case statement like

Please Login or Register  to view this content.

That's rather efficient... I never thought of doing it by using cases. I will switch it out now.

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.