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

[Stephen Simons]

Hi

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

for example, if A1 contains the name "Fred Flintstone" I would like the macro to name cell A1 "Fred_Flintstone"

The cell reference will always be A1.

TIA

Steve

 

[Tom Ogilvy]

ActiveCell.Name = activeCell.Value

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

Hi

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

for example, if A1 contains the name "Fred Flintstone" I would like the

macro to name cell A1 "Fred_Flintstone"

 

[Stephen Simons]

Thanks Tom. It worked perfectly.

Steve