vba - need to find the type mismatch in this line of code

B

bourassa

While Worksheets("Log-Import").Cells(counter, LogCol).Value And
Worksheets("Log-Import").Cells(counter, UsernameCol).Value And
Worksheets("Log-Imports").Cells(counter, DayCol).Value <> "Logoff" And
username And Cells(counter, DayCol).Value

i cant find the type mismatch please help
 
B

Bob Phillips

We won't be able to help you as it will depend upon the values of the
variables.

Check all of the statements in the watch or immediate windows.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
H

Harlan Grove

We won't be able to help you as it will depend upon the values of the
variables. ...
Click to expand...
...

While Bob is correct in general, in this particular case there's one possibility
that stands out - username. If it's a text string (likely!), then it'll fubar a
boolean expression. That's what I'd guess was throwing the type mismatch error.
 
Top