Hi All,

Is it possible to program a macro that will add a user
entered value in cell ("c1") to a range of cells c2-c15.

Then if the user chooses, add another value entered into
("C2"),to a reduced range of cells c3-c15, so each time I
am eliminating the value in the preceeding cell reference.

The spreadsheet, comprised mainly of formula is linked to
a standard chart but it can be adjusted by entering manual
values in the c column, so for the chart to work I have to
keep adding the manual numbers entered to each cell in the
range except the cell in which the manual value was
entered.

Does that make any sense ?, Any help even to part of the
query would be great.

Thanking you in advance

Mike