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
I have tried
Range("Name") =
Range(Name) =
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
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)
P
Peo Sjoblom
Depends what you are trying to do
Range("Name").Value = "Hey"
Range("Name").Value = "Hey"
F
Frank Kabel
Hi Dave
normaly
Range("your_defined_name").value = x
should work. what result did you get?
Frank
normaly
Range("your_defined_name").value = x
should work. what result did you get?
Frank
D
Dave Griffiths
Guess what guys, it works now. I thought it should.Bob said:Dave,
What happened when you tried
Range("Name") =
Thanks for the quick response.