VBA index

**Cobra17** · 01-19-2023, 03:25 PM

I can't seem to get this index to work in VBA

Please Login or Register  to view this content.

the Index comes back with wrong number of arguments or invalid property assignment.

"a" is the row value I'm looking for
SP1 is the table name
'Mx" is the table header name i'm looking for

**davesexcel** · 01-19-2023, 04:03 PM

What should the formula look like without VBA?

VBA index

LinkBack

Thread Tools

Rate This Thread

Display

VBA index

Re: VBA index

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Index Match not cycling through entire index. Formula not updating when values change...

[SOLVED] Index/Aggregate formula calculates correct row but does not yield name from Index array

Filter Sort Issue on Index Match (column with formula Index Aggregate)

[SOLVED] Use Weekday function with (Countif Sumproduct, +Index) also If(IsError(search(mid +Index

[SOLVED] Index un-indexed items keeping original index numbers where they exist

[SOLVED] Converting Hlookup to Index Match with variable column index number

Excel Index Function - Matching calendar dates and activities using an index fuction

Bookmarks

Bookmarks

Posting Permissions