Naming Cells with Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
After Macro runs, no cell activated - what am I missing? 2
Pasting cell contents into a macro 1
Copying & Pasting with recorded macros 9
select cell by variable name 6
Help with Excel Hyperlinks macro? 6
Macro - insert slashes into a cell 1
How can a macro copy from a named array to an inserted row 2

Back
Top