Here is one way...

=SUM(OFFSET(INDIRECT(First_Cell&":Z1"),1,0))

Rick


"sevi61" wrote in message
...
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.