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:
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:
Bookmarks