It seems the more I learn about VBA, the more I want to do with it!

I am trying to use Excel's INDEX function in VBA to return a value from
the second column in a list from a sheet labelled "Set Up"...is this
proper syntax, because I get nothing:

MET = Application.Index(Range("Set Up!$AY$6:$AZ$149"), 57, 2)

MsgBox "Returned value is " & MET

...(I have defined all variables earlier)

None of my books cover using INDEX in VBA, what you see above I have
gleaned from earlier posts here, hoping it would work.

I would really appreciate any feedback here, so I can go farther!

-Dave


--
Applewine
------------------------------------------------------------------------
Applewine's Profile: http://www.excelforum.com/member.php...fo&userid=5512
View this thread: http://www.excelforum.com/showthread...hreadid=520907

Well it was an obvious Syntax violation!
(What was I thinking)

Application.INDEX(Worksheets("Set Up").Range("----

Instead of

Application.INDEX(Range("Set Up!----

Thanks anyway!

-Dave


--
Applewine
------------------------------------------------------------------------
Applewine's Profile: http://www.excelforum.com/member.php...fo&userid=5512
View this thread: http://www.excelforum.com/showthread...hreadid=520907