Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I am using below code to enter time
I want to make it, offset one column if active cell is in column G
and OFFSET one row and one column if active cell is in column H
I want to make it, offset one column if active cell is in column G
and OFFSET one row and one column if active cell is in column H
VBA Code:
Sub iTime()
With ActiveCell
.Value = Format(Time, "hh:mm")
.Offset(0, 1).Select
End With
End Sub