Sum after last row once data is pasted

for example you has paste to columns(1) then
try this

Please Login or Register  to view this content.

Why do you need VBA.

Just create a dynamic range name that will expand or contract in response to the size of the data you paste and then use the name in a bog standard SUM formula

e.g. =SUM(MyRangeName)

Hi ~TaC~,

Could something like this work for you if the dynamic named range won't work.

Please Login or Register  to view this content.

Originally Posted by ~TaC~

This works but I need to run the macro each time for it to show total?

@Richard Buttrey

The idea of asking for help is because I don't know how to do it, I know how to do a bog standard sum but how would it know to display in the cell after the last row?

Does it really need to be in the cell underneath the last item?
Surely the days of totals at the bottom of a list went out of fashion after we ditched pencil and paper and went digital.

The best place for totals is in a fixed cell above the data. If it needs to be visible all the time then either set a freeze pane underneath the total, or an often forgotten - (or never known way) is to use the camera tool and take a shot of the total cell then move the camera image to wherever you want.