i keep getting this error when i am tring to call this function
Function totalitems(totalitems)
UserRowCounter = UserStartRow
While Worksheets("Log-Import").Cells(UserRowCounter, UserStartCol) <> ""
UserRowCounter = UserRowCounter + 1
Wend
totalitems = UserRowCounter
End Function
'function to be the do all end all find logoff for each coresponding logon.
Function Findlogoff(totalitems)
itemcount = 0
totalitems (totalitems)
For counter = 1 To totalitems
If LogCol = "logoff" Then
If UsernameCol = username Then
If DayCol = UserDayCol Then
Worksheet(username).Cells(userrow, UserLogoffCol).Value = Worksheets("log-import").Cells(logrow, LogCol).Value
itemcount = itemcount + 1
End If
End If
End If
Next counter
If itemcount = 0 Then
MsgBox "there were no logoffs found for & username & on that day. would you like to continue."
End If
End Function
'Call a logoff function here
Findlogoff (totalitems)
please help this is the last thing i need i promise