Chi,
hopefully someone can help with this;

I have a named cell (First_Cell) which changes each month ie A1,B1,C1. I
have a formula that sums First_Cell:Z1 I am trying to write a macro that will
take the column reference (A,B,C) that First_Cell is in, go down 1 row and
sum from that column to the end of the range (if First_Cell is in cell C1, I
need the macro to sum from C2:Z2).
any assistance provided would be gratefully accepted.