can i put a variable inside timeserial?

[earp_]

I have this

'7.05
If .Value >= TimeSerial(7, 0, 0) And .Value < TimeSerial(7, 5, 0) Then
With ThisWorkbook
Worksheets("Sheet1").Range("B2").Copy
Worksheets("Sheet2").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlValues
End With
End If

If I want to change

TimeSerial(7, 5, 0) into TimeSerial(7, 10, 0)

using a variable X, is it possible?

 

[Richard Schollar]

Just make your TimeSerial expresiion be:

TimeSerial(7, X, 0)

and then adjust whatever value X holds which will then flow thru to the timeSerial expression.