Run Time Error 13 Type Mismatch on VBA VLOOKUP

I apologize for posting this and hope nobody has spent time on it. I've found the issue. I had a cell referenced as II12 which should have been I112. The change corrected the error.

I will close this thread now.




My Macro is getting a type mismatch on a VLOOKUP on the second pass. The Macro is running on a worksheet for a double elimination bracket tournament. It's purpose is to check the brackets where a doubles team name would appear and assign a color to the cell.

The Colors Array is in B81:I112

So I have an outer loop (OLoop) and Inner Loop (ILoop) to locate a bracket with a doubles team name.

The first pass thru the vba instruction works fine but on the second pass it gets a type mismatch and the cell is set as general in both rows.

Here's the macro code and the mismatch is on: this line of code:

Please Login or Register  to view this content.

I could change code and check every row thus avoiding the vlookup but I'd rather understand why the mismatch and be more efficient. I don't think it would make a significant difference in run time.

I am attaching three workbooks but the macro is only involved with workbook: DoubleElimDrawSheet.xlsm which has formulas to pull data from the other 2 workbooks.

Thanks for any help and my macro code follows:

Please Login or Register  to view this content.