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:
Sub Button_Click()
ActiveCell = Now()
ActiveCell.NumberFormat = "hh:mm:ss"
ActiveCell.Offset(0, 1).Select
End Sub
Code:
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
_________________
vskid wrote:
Nerd = likes school, does all their homework, dies if they don't get 100% on every assignment
Geek = likes technology, dies if the power goes out and his UPS dies too
I am a geek.
Login
FAQ
Search
