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.

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.