Macros
 

Hello and How are you
I was wondering if anyone could help me with the code in macros in
excel 97. What I have done is set up for a race and whenever someone
crosses over the finish line the timer hits a button and the time is
recorded. What is the code to make it go to the next line down
(Vertically) so that the timer doesn't always have to have it on the
right cell.


Here is the code I have already done

Sub Button1_Click()
'
'Button1_Click Macro
'Macro recorded 12/15/2003 by Jessica
'
ActiveCell.Value = Time
ActiveCell.NumberFormat = "hh:mm:ss"
'
End Sub


Thankyou and have a great day

Jessica



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/