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.
|