NessPJ
Active Member
- Joined
- May 10, 2011
- Messages
- 422
- Office Version
- 365
Hello all,
I keep getting a Type: Mismatch error on the following code (orange line):
I also tried putting Tijdwaarde As String, since i use a "TimeSerial" function but that did not seem to solve the issue.
Any ideas what i'm doing wrong here?
I keep getting a Type: Mismatch error on the following code (orange line):
Rich (BB code):
Dim Tijdwaarde As Variant
Tijdwaarde = Sheets("Par").Range("B30").Value
LastRowATImpSht = Range("C" & "65536").End(xlUp).Row
For i = 2 To LastRowATImpSht Step 1
Range("F" & i).Value = Format(Range("F" & i).Value, "HH:MM") - TimeSerial(0, Tijdwaarde, 0)
Next i
I also tried putting Tijdwaarde As String, since i use a "TimeSerial" function but that did not seem to solve the issue.
Any ideas what i'm doing wrong here?