WorksheetFunction.Index producing error
 

I am getting a Run-time error '438': Object doesn't support this property or
method at the following line:
MsgBox (ActiveWorkbook.WorksheetFunction.Index("TABLES!C6 123:C6133",
Target))

This is in a Worksheet_Change event. Instead of the user entering long
text, I have put in the "Input Message" of Data Validation 11 entries and
their corresponding values, so the user just has to enter an integer from 1
to 11. I realize I could use a LOOKUP function, but I still don't know what
is wrong with the above code. Any help?
--
TIA, Brad E.

WorksheetFunction.Index producing error
 

MsgBox
Application.WorksheetFunction.Index(Worksheets("TA BLES").Range("C6123:C6133"),
Target.Value)


--
__________________________________
HTH

Bob

"Brad E." wrote in message
...
I am getting a Run-time error '438': Object doesn't support this property
or
method at the following line:
MsgBox (ActiveWorkbook.WorksheetFunction.Index("TABLES!C6 123:C6133",
Target))

This is in a Worksheet_Change event. Instead of the user entering long
text, I have put in the "Input Message" of Data Validation 11 entries and
their corresponding values, so the user just has to enter an integer from
1
to 11. I realize I could use a LOOKUP function, but I still don't know
what
is wrong with the above code. Any help?
--
TIA, Brad E.