Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Name issue
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range.Select Issue | Excel Programming | |||
Range issue | Excel Programming | |||
Range issue... | Excel Programming | |||
Copy Range Issue | Excel Programming | |||
Excel Range issue | Excel Programming |