I get an "Invalide Qualifier" Error on part of my code.
I first define a Type
And then on this line I get the "Invalid Qualifier"
MyDefaultSheet is a name I give to the function in an inputbox. MyRange is created by input from another inputbox and the count of a for loop. Any idea why I would get that error. I've worked with Types before without problem.
I first define a Type
Code:
Type Account
CompareString1 As String
CompareString2 As String
OnRow As Long
Found As Boolean
End TypeAnd then on this line I get the "Invalid Qualifier"
Code:
Accounts1.CompareString1 = Sheets(MyDefaultSheet).Range(MyRange).ValueMyDefaultSheet is a name I give to the function in an inputbox. MyRange is created by input from another inputbox and the count of a for loop. Any idea why I would get that error. I've worked with Types before without problem.