brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I am running a macro in a worksheet - 12 set up for every month from March to February (Mar to Feb)
I have a hidden sheet set up for a log to record the date and time each time the macro is run
The log sheet is set up with each month heading in row 2 from Mar is column A to Feb in column L
I want to know if I am able to set up code to enter the timestamp in the log sheet under the relevant month (Now()) in the next empty row without having to go to the Log sheet
The logsheet uses a password BB2 to unprotect it.
Can anyone assist
I have a hidden sheet set up for a log to record the date and time each time the macro is run
The log sheet is set up with each month heading in row 2 from Mar is column A to Feb in column L
I want to know if I am able to set up code to enter the timestamp in the log sheet under the relevant month (Now()) in the next empty row without having to go to the Log sheet
The logsheet uses a password BB2 to unprotect it.
Can anyone assist