Sounds like your problem is revealed in the phrase "whencopy it down".
If you are staying in the same column, Excel has no reason to change the
column part of your formula.

Instead, copy the formula to the right - which will cause Excel to
generate cell formulas like you want. Then copy the formulas and use
Paste Special Transpose to get them into a column...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113061