Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Cells with Macros
Is it possible to define cells using macros? I've tried creating a macro by
recording myself naming three cells three different things with the relative reference on. When I try to apply the macro to a row below, it doesn't name the new cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Cells with Macros
Yes, it's possible. The code should be something as follows. The new
name should be in quotes and can't contain spaces. Range("a1").Name = "nametoset" Cells(1,1).Name = "nametoset" aynsley wrote: Is it possible to define cells using macros? I've tried creating a macro by recording myself naming three cells three different things with the relative reference on. When I try to apply the macro to a row below, it doesn't name the new cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming cells... | Excel Worksheet Functions | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |