You would need to add some test to the formula. What is that formula, and
what sort of data in A1?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Altec101" wrote in
message ...

Hello,

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

I have a formula in cell B1, which checks numbers in cell A1, and based
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 of
data in cell A1 can be different each time.

Thanks


--
Altec101
------------------------------------------------------------------------
Altec101's Profile:
http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=571898