hey folks

I've got a row with a simple set of sequential numbers - 1-10.

I'm trying to figure out how, if possible, to have the row recalculate
the list of numbers if one is removed.

For instance, if I delete the number "3" from cell C1 I want all the
cells to shift over to the left so that the last cell in the row is
blank not cell C1.

Sorry, this seems a bit confusing so please let me know if I can
clarify further.

Thanks for any help
Keith


--
kayos
------------------------------------------------------------------------
kayos's Profile: http://www.excelforum.com/member.php...o&userid=23974
View this thread: http://www.excelforum.com/showthread...hreadid=375975