Hi,

I'm VERY new to this but have picked up a bit already.

I have the columns already selected by way of my macro, but I need to be able to perform a sum on each.

The spreadsheet changes in size weekly, so I don't want to the rows "hard coded" in the macro.

Can anyone help here?

Like I said I've already got the end of each column selected. So it's just a matter of running the sum formula in there.

Any assistance you can provide would be really appreciated.

Thanks!