Thanks for all your help, Rick. you've answered all my questions for me and
it works great now. I really appreciate it.

"Rick Rothstein (MVP - VB)" wrote:

In my last posted routine, change this line...

With Worksheets("Sheet1")

to this...

With ActiveSheet

Rick


"valiant" wrote in message
...
One last question I just came across during my attempts. I realized if I
rename the worksheet or try to get the macro to work with another
worksheet,
it doesn't work anymore and I get an error message. How can I make it so
that this macro can be used with whatever the worksheet is named and
potentially with multiple worksheets (So if I were to activate the macro
in
sheet 1, it would show the results in sheet 1, then I could activate it in
sheet 2 without changing the macro and it would show the results in sheet
2)?
Sorry for the barrage of questions, I'm kinda new to macros in Excel.
Thanks for the help.

"valiant" wrote:

Hello,
I'm looking to create a macro with similar function to that of a time
clock
used in work shops (one that when activated will copy the current time
(preferably seperated from the date) into another cell for use with other
equations). It should also fill it in like a list whenever the macro is
activated (so it fills in, for example, cell A1 when the macro is first
activated and the next time it is used it will fill in the current time
in
A2). Can anyone help me with this? I appreciate it.