Re: referencing a name from another book

thanks Tom! that's perfect, however i should have specified...
i need this in a cell formula version

the formula i am using is a sumproduct formula which looks like

=sumproduct((MyNamedRange1="A")*(MyNamedRange2))
(as an array formula)

i am copying this *** to another workbook and need to reference it from
the new workbook

ie if i am referencing a cell from another workbook i do
=[Book2.xls]My***!$E$44

i need to do the same thing, but reference the Named Range instead

that a bit clearer?


thanksi!

J
"Tom Ogilvy" wrote:

> Dim bk as Workbook
> Dim rng as Range
> Dim bNotOpen as Boolean
> on Error Resume Next
> set bk = Workbooks("Book2.xls")
> On Error goto 0
> if bk is nothing then
> set bk = Workbooks.Open("C:\temp\book2.xls")
> bNotOpen = True
> End if
> set rng = bk.Names("MyNamedRange").RefersToRange
> v = rng.Value
> if bNotOpen then
> bk.Close SaveChanges:=False
> set rng = nothing
> set bk = nothing
> End if
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Gixxer_J_97" <GixxerJ97@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B9DBEA6F-E0BF-41D1-84C3-D5794B472045@xxxxxxxxxxxxxxxx
> > hi all
> >
> > how do i reference a named range from another book?
> >
> > just a generic example would be sufficient
> > ie if my named range is
> >
> > 'MyNamedRange' and it is defined in the workbook 'Book2.xls' on work***
> > MySheetName in path c:\temp
> >
> > how do i reference MyNamedRange in 'Book3.xls'
> >
> >
> >
>
>
>
.