Auto sum data in first blank cell

[duugg]

Hello all,

I have this code here that is supposed to Auto-sum 3 columns for me...

Please Login or Register  to view this content.

This code is supposed to Auto-Sum the numbers in column H, I & J and total them one row below the row of data in the "Customer Number" column.

It only works this way if there are no blank cells in each respective column all the ways down to the customer number column.

I need this macro to stop adding the column once it gets to the bottom-most row of data in the "Customer Number" column which is never in a fixed position and is always in row 1.


Also, if possible, I'd like to change how it searches the columns. Instead of "H", "I" & "J", I'd like it to find the columns by name rather than by fixed position because the position can change every time I run the report.

How can I get this code to auto-sum the 3 columns named "Cost 1" and "Cost 2" and "Cost 3" and then put these totals one row below the last row of data in the "Customer Number" column?

Note that there can be many blanks in any of these 3 columns so I need it to continue PAST any blanks and keep going until it gets to the last row of data in the "Customer Number" column.

I would then like that row (whatever that row may be, because it will be different every time I run the report) to be bold, red, centered vertical and a row height of 18.

Thanks much!

[StephenR]

We do get a lot of repeat custom from you duugg. Give this a try.

Please Login or Register  to view this content.

[duugg]

I did try to adjust the existing code myself with no luck.

Your code worked perfectly though,

Thanks much Stephen!