index function in VBA

[c1802362]

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

is there a comparable VBA function (xlIndex?)

Art

 

[Mike Middleton]

c1802362 or Art -

There's the OFFSET property of the RANGE object.

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

 

[Bob Greenblatt]

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