Hi,

How is your macro supposed to know how far up to go? Do all the cells need
values or do you some from the current cell to row 1 or column A as the case
may be?

--
Thanks,
Shane Devenshire


"New user" wrote:

Do anyone know if i want to set a macro which i want to comprise 2 elements:

1: total underline
2: sum ("Sum" function in Excel which automatically sum up all the cells
with figures)

Every time i set, the no. of cells to be added are fixed. for example, Col A
has 3 cells to sum up; when i apply it to Col B which has 5 cells, it also
only add up the last 3 cells, not 5.

Can anyone advise me on this matter?

Thank you so much.

--
New user