Thread: 3D Named Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TOMD TOMD is offline
external usenet poster
 
Posts: 33
Default 3D Named Range

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.