Named cells

  • Thread starter Thread starter Dave Griffiths
  • Start date Start date
D

Dave Griffiths

How do I use a name of a cell rather than the R1C1 address.

I have tried
Range("Name") =
Range(Name) =

Thanks
 
Dave,

What happened when you tried

Range("Name") =

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Depends what you are trying to do

Range("Name").Value = "Hey"
 
Hi Dave
normaly
Range("your_defined_name").value = x
should work. what result did you get?

Frank
 
Bob said:
Dave,

What happened when you tried

Range("Name") =
Click to expand...
Guess what guys, it works now. I thought it should.
Thanks for the quick response.
 
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

VBA function to define name in a worksheet 2
Named range with multiple groups of cells 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
cell address rather than range name 1
Range selection with R1C1 6

Back
Top