index function in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

c1802362 - 06 May 2008 01:56 GMT

excel has the built in function Index(range, row_no, column_no)

is there a comparable VBA function (xlIndex?)

Art

Reply to this Message

Mike Middleton - 06 May 2008 02:16 GMT

c1802362 or Art -

There's the OFFSET property of the RANGE object.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> excel has the built in function Index(range, row_no, column_no)
>
> is there a comparable VBA function (xlIndex?)
>
> Art

Reply to this Message

Bob Greenblatt - 06 May 2008 12:39 GMT

On 5/5/08 8:56 PM, in article
0e864845-5026-4458-a027-a511d2ac2a2b@c58g2000hsc.googlegroups.com,

> excel has the built in function Index(range, row_no, column_no)
>
> is there a comparable VBA function (xlIndex?)
>
> Art

And, in addition, you can use application.index

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / May 2008

index function in VBA