vodkasoda
03-11-2009, 07:55 AM
I have attached my Spreadsheet, this is very odd, or I have done something very stupid !!!
I have 2 definitions as follows ...
Public MyUniqueNo As Integer
Public MyNoOfTeams As Integer
I have 2 statements as follows ...
MyUniqueNo = Sheets("Players").Range("A65536").End(xlUp).Value
MyNoOfTeams = Sheets("Teams").Range("A65536").End(xlUp).Value
I am getting an error on the 2nd line, "Run-time error '13': Type mismatch" ... I can switch the variables and it always works unless I am using the "Teams" sheet, whereas I always get this error ... why :think: ?!?!?
Many apologies if this is embarrasingly stupid, but I just can't see it !!!
I have 2 definitions as follows ...
Public MyUniqueNo As Integer
Public MyNoOfTeams As Integer
I have 2 statements as follows ...
MyUniqueNo = Sheets("Players").Range("A65536").End(xlUp).Value
MyNoOfTeams = Sheets("Teams").Range("A65536").End(xlUp).Value
I am getting an error on the 2nd line, "Run-time error '13': Type mismatch" ... I can switch the variables and it always works unless I am using the "Teams" sheet, whereas I always get this error ... why :think: ?!?!?
Many apologies if this is embarrasingly stupid, but I just can't see it !!!