| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to use a cell's contents as it's name
ActiveCell.Name = activeCell.Value
Make sure the value of the cell is a valid name. For example, no embedded spaces. -- Regards, Tom Ogilvy "Stephen Simons" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
| Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
| link to a cell's contents | Excel Worksheet Functions | |||
| Rotate a box with a cell's contents | Excel Discussion (Misc queries) | |||
| Macro Button To Modify A Cell's Contents? | Excel Programming | |||
Hybrid Mode
