VBA programming question

Do you have a technical question that doesn't really fit a specific console? Want some general info on electronics, hacking, making cookies, etc? Here's the place to ask! Go nuts.

Moderator: Moderators

Post Reply
User avatar
Sparkfist
Forum Administrator
Posts: 6754
Joined: Tue Apr 20, 2004 7:12 am
Location: Michigan
Contact:

VBA programming question

Post by Sparkfist » Thu Apr 19, 2012 8:21 am

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
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.

Post Reply