Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I ran into this problem in 2000 and had to use LOTUS instead. I figured that
it had been fixed in 2003, but it appears that I'm wrong. I create a 3D Named Range, per the Help File, and several Online Sites, which say exactly the same thing, but it doesn't work for me. It seems as though it's been created, because it shows up in the Define Name Window, but it doesn't show up in the Named Range List on the Worksheet. Nor can you reference it in a Macro. The Named Range as it is shown in the Define Name Window: =sch_jnt_acct:sch_atd_last!$f$2:$f$100 Any assistance would be greatly appreciated, as I don't want to go back to LOTUS. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) |