Macros

[jdorion]

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.

Thankyou and have a great day

Jessica

 

[tomhaddock]

Hi

There are several ways but it's not clear how the system of yours
works. Do you mean that the timer automatically put the time in the
spreadsheet? Then in that case:

ActiveCell.Offset(1 ,0 ).Select (or .Activate)

then reloop your code.

If you mean entering the time manually then a simple Enter or Down key
should take you to the next cell down.
It would be easier for us if you describe or paste the code of your
system.

Tom