I'm working on a Time Sheet for work. Got the basics done, but need to make a macro that can simplify things. Namely have the range specified and the active cell shift back to start and down one row at the end.
Here's the layout, it's big so be warned.
And here is the code I have.
Code: Select all
Sub Button_Click()
ActiveCell = Now()
ActiveCell.NumberFormat = "hh:mm:ss"
ActiveCell.Offset(0, 1).Select
End Sub
Code: Select all
Range("C4:F8").Select
-Sparkfist