when the range in the index() is a link

VBAnewbie · Nov 8th 2004

Hi,

I'm using an index function like this = index(A1, 1,1) where in Cell A1
is the text Range1. Range1 is the name of the range of cells that I
defined.

However, =index(A1,1,1) does not work! Nor = index(""&A1,1,1)!!

What is the correct sytnax for this !!

Any help is appreciated!!

Thanks,
Kim

Anonymous · Nov 8th 2004

Re: when the range in the index() is a link

Try
=INDEX(INDIRECT(A1),1,1)

**Batman** · Nov 8th 2004

Re: when the range in the index() is a link

Hi Kim,

The correct syntax should be

=INDEX(INDIRECT(A1),1,1)

Hope this helps.

Regards,
Batman.

A9192Shark · Nov 8th 2004

Re: when the range in the index() is a link

Kim,

Assuming that Range1 is a named range on your worksheet then
=index(Range1,1,1) will return the value in row 1, col 1 of the named area.

HTH,

Alan.

VBAnewbie · Nov 8th 2004

Re: when the range in the index() is a link

Thank you all!!

Now I got it!!

Kim

Participate now!