Formula
 

I need to have a formula that can add a row of cells with a variable
number of colmns. Columns will be added and deleted everyday, so the
formula needs to have a variable range.

I hope this is clear.

Thanks,
Bernie

Formula
 

Use dynamic named ranges. See here for more details:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Dave
--
Brevity is the soul of wit.


"Bernie" wrote:

I need to have a formula that can add a row of cells with a variable
number of colmns. Columns will be added and deleted everyday, so the
formula needs to have a variable range.

I hope this is clear.

Thanks,
Bernie