Finds last occurrence of a match in a column
Finds the row of last time an item found in a column
That is until a blank space is found
Uses Range().End, not the best way, but works the fastest
Been thinking about this one for a while now, and needed it a lot across my 22 years with Excel-VBA.
Works exactly like MatchIf and VMatchIf, just finds the last item in a column.
Should be working with no issues in xls or xlsx workbooks (65k or 1m rows)
It is actually starts searching from last row (1m in xlsx or 65k in xls) then goes up until a non-blank cell found, then loop through that column until a first match is found for that item we are looking for
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
Views 2,787
Downloads 809
