ExcelBanter - View Single Post - macro to use a cell's contents as it's name

Thread: macro to use a cell's contents as it's name

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Stephen Simons Stephen Simons is offline

Stephen Simons is offline

external usenet poster

Posts: 5

Default

macro to use a cell's contents as it's name

Thanks Tom. It worked perfectly.

Steve

On Thu, 10 Jun 2004 15:41:18 -0400, "Tom Ogilvy" wrote:

ActiveCell.Name = activeCell.Value

Make sure the value of the cell is a valid name. For example, no embedded
spaces.

Reply With Quote

Reply With Quote