Hi
In my spreadsheet I need to add a Sum formula.
However the Sum range will vary each time the report is run.
The Sum range always starts in cell M13, but the end range could be R13 or S13 etc.
Then this Formula needs to be filled down to the last row in the data range.
So basically I need a way of defining the range to Sum each time.
I would need to be able to do this in VBA too.
Can anyone help?
Thank you all in advance
Bookmarks