Range Name issue
use Application.Evaluate("P_bar")
--
Haldun Alay
"Barb Reinhardt" , haber iletisinde
şunları ...
I have created a named range with a single value in it and I can't seem to
access it within my VBA code. This is what I have so far. I've put it
in
a debug.print statement to see if I can see what's going on and it gacks
each
time.
Debug.Print Range("P_bar").Text
Debug.Print Range("P_bar").Value
I get a
Runtime error '1004'
Method 'range' of object '_Global' failed.
I can access the named range from the worksheet, just not the macro. The
named range is a workbook range, not a worksheet range.
Thanks,
|