Hi,
Is there a way to sum a range of cell, without actually reffering to the cel refferences. I am currently writing a macro which formats a variable length worksheet. Consequently I am having to use words in cells to define my selection, rather than the cell refferences. I need to find a way of summing the values between a cell named "Household" and a cell named "Subtotal". Both values are stored in column C, and the number of rows between these field changes so I can not hard wire in the actual formula.
Can anyone help!!
Cheers
Nova30
Is there a way to sum a range of cell, without actually reffering to the cel refferences. I am currently writing a macro which formats a variable length worksheet. Consequently I am having to use words in cells to define my selection, rather than the cell refferences. I need to find a way of summing the values between a cell named "Household" and a cell named "Subtotal". Both values are stored in column C, and the number of rows between these field changes so I can not hard wire in the actual formula.
Can anyone help!!
Cheers
Nova30