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.