VBA Sum from a specific cell to a relative cell

[Finalfight40]

Hi All

I am looking for a little bit of advice for a formula in VBA.

I created a macro but while testing it i noticed that this line of code was not going to be correct for all situations.

ActiveCell.FormulaR1C1 = "=SUM(RC[-10]:RC[-1])"

I would like it to sum from B3 to RC[-1] but of course just replacing RC[-10] with B3 would just be too easy.

Also if it matters, the formula does get copied down the column later on where B3 would then need to change to C3, D3, E3 etc.

Thank you for any advice.

 

[Fluff]

How about

 "=SUM(RC2:RC[-1])"

 

[Finalfight40]

Also if its possible, sum from the 2nd column on the active row to RC[-1] because i know that further on in my macro i have to do the same thing but for a column. This would change because of the filters applied before the macro runs and so sometimes the table would finish on Column N but other times might finish on Column AX for example.

Would be a very good thing to know so that i can adapt for this project and future projects.

 

[Finalfight40]

How about

 "=SUM(RC2:RC[-1])"

Sir you are my hero.

Please ignore my 2nd post because i can adapt what you have provided me i believe.

 

[Fluff]

Glad to help & thanks for the feedback