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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Using a named range in the Worksheet_Change event 3
Excel Macro error 5
Button Focus 3
VBA: Paste in a range 6
Simple Copy Paste within Worksheet Change Event 2
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Change event code Find .Activate does not activate Target.value 4

Back
Top