VBA programming question

[Sparkfist]

Ok guys got a question and I hope someone has experience with VBA in Excel.

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

Anyone know how to put the range in so it works and have the Active cell shift move to the next row when it reaches the last column... I know I'm a total programming noob.

-Sparkfist