WorksheetFunction.Index producing error

  • Thread starter Thread starter Brad E.
  • Start date Start date
B

Brad E.

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!C6123: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?
 
MsgBox
Application.WorksheetFunction.Index(Worksheets("TABLES").Range("C6123:C6133"),
Target.Value)
 
Back
Top