Time Stamp written to a hidden sheet

[enhydra]

Hi All,

With help from Mike Rickerson on Excel Forum, I was able to get the stamp time running on my worksheet. I'm now trying to get the time stamp to write on a different sheet that will be eventually be hidden. Does anyone know how to change this code to write to a different sheet?

Please Login or Register  to view this content.

Thanks,

E

[gmr4evr1]

Just cut and paste the code from the worksheet that it is on to the worksheet that you are going to have hidden.

[leelnich]

Code updated 14 May 2017 14:25 - LLN
Nope, sorry gmr4evr1, that won't work. The events being responded to occur on the original worksheet, so the code has to stay there:

Please Login or Register  to view this content.

You weren't specific about where to put the timestamp, so I mirrored the original address. But you get the idea...

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[gmr4evr1]

My bad, I realized a few minutes ago that I gave enhydra bad info. Fortunately another member was on their toes and gave correct info.
Thanks for the help leelnich.

[enhydra]

Thank you Leelnich, you are correct. The code is looking for a change C3:C42 on sheet1 and I want to time stamp on sheet2 starting with column S related to the change with sheet1. It counts the last column of time stamp and increments to the next column. Unfortunately I can not get the code that you posted to work, it doesn't show any time stamp. So i really want it stamp on sheet2 in the same place it is now placing it with sheet1.

Thanks,

E

[leelnich]

I updated the code in post #3 at about the same time you posted #5. Please try the new code and see if it works.
(NOTE: I assume you changed the worksheet name to match your hidden sheet name.)

[enhydra]

Yes the sheets are simple, sheet1 and sheet2. I change the code and getting a "subscript out of range" error on this line. With Worksheets("sheet2").Range(tAddress)

[enhydra]

Wait, it's working. I was getting some strange errors so I rebooted and it is now working.

[leelnich]

Strange, it's working fine for me. I don't protect my workbooks though, maybe that's the problem. Check the attached workbook.
OK, Great! Glad I could help. If you're satisfied, please mark the thread SOLVED. Take care.-Lee

[enhydra]

Lee, thank you so much.