Frank Kabel--Kindly help again?

[JRocket02]

Hi Frank,

I'm a fairly experienced Excel developer, but a complete NEWBIE poster. I'm
sorry, but for reasons unknown to me I cannot find your answer to a recent
post of mine, or the post itself. Don't know what I'm doing wrong, but the
issue was:

I would like to use named cells from the spreadsheet and use them in VBA.
You gave me a nifty little way to do that, something like--

Dim Range("CellName") as double

Or something to that effect, but I sure can't remember what it was, and the
post is gone. Your help will again be greatly appreciated. Thanks.

 

[Frank Kabel]

Hi
for posting / finding posts see:
http://www.mvps.org/dmcritchie/excel/posting.htm

Also it is always better not to address a question to one specific
person. Just ask your question and someone will answer it

To your question. You probably meant something like

Dim rng as range
set rng = range("your name")
msgbox rng.value