Bob,

I have a column of numbers (each cell contains a number), with a fixe
starting cell but a variable ending cell. I want the macro to assign
Name (Workbook definition) to this range.

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26589

Set TopCell = Range("A1")
Range(TopCell, TopCell.End(xlDown)).Name = "SomeName"


On Mon, 4 Oct 2004 21:17:01 -0500, Chuckles123
wrote:


Bob,

I have a column of numbers (each cell contains a number), with a fixed
starting cell but a variable ending cell. I want the macro to assign a
Name (Workbook definition) to this range.

Chuckles123