View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian G
 
Posts: n/a
Default 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.