Hello,

How can I have a formula end at a certain range of cells withou
knowing that range of cells ahead of time?

I have a formula in cell B1, which checks numbers in cell A1, and base
on the number in A1, the formula changes B1 to a letter.
I copied the formula down so far in the B1 range, but the length o
data in cell A1 can be different each time.

Thank

--
Altec10
-----------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...fo&userid=3453
View this thread: http://www.excelforum.com/showthread.php?threadid=57189