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
external usenet poster
  
Posts: 5
Default macro to use a cell's contents as it's name
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
Reply With QuoteReply With Quote