Formulas in Merged cells
 

If you have a worksheet column that contains merged cells of various sizes
and that column needs to increment the value based on the previous merged
cell you can't copy and paste or autofill from one cell to the next becuase
of the changing cell references. How do you get around this without having to
write a new formula for every cell?
eg: Column A1 contains the number 1. The next cell is A2/A3 merged and the
cell contains the formula "=A1+1". This works but if you copy this formula to
the next cell which is A4/A4/A6 merged the formula does not work.
Is there a way around this?

Formulas in Merged cells
 

Personally I find merged cells to be more trouble than they're worth. I'd
seriously consider avoid having merged cells, so that you don't have to deal
with this sort of thing.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"TooBaaaadd" wrote:

If you have a worksheet column that contains merged cells of various sizes
and that column needs to increment the value based on the previous merged
cell you can't copy and paste or autofill from one cell to the next becuase
of the changing cell references. How do you get around this without having to
write a new formula for every cell?
eg: Column A1 contains the number 1. The next cell is A2/A3 merged and the
cell contains the formula "=A1+1". This works but if you copy this formula to
the next cell which is A4/A4/A6 merged the formula does not work.
Is there a way around this?

Formulas in Merged cells
 

Now you see one of many reasons why many people recommend avoiding the use
of merged cells.
--
David Biddulph

"TooBaaaadd" wrote in message
...
If you have a worksheet column that contains merged cells of various sizes
and that column needs to increment the value based on the previous merged
cell you can't copy and paste or autofill from one cell to the next
becuase
of the changing cell references. How do you get around this without having
to
write a new formula for every cell?
eg: Column A1 contains the number 1. The next cell is A2/A3 merged and the
cell contains the formula "=A1+1". This works but if you copy this formula
to
the next cell which is A4/A4/A6 merged the formula does not work.
Is there a way around this?