Hello,
What I am trying to do is use a macro to enter specific information on the current row ie. today's date, the time as at the time of entry etc. The date is easy as I have the macro enter =today() and then go back Copy | Paste Special | Value with the same macro.
What I would like is that the time enters as it is at that particular moment. That is to say that at 12:08 that the cell remains as 12:08 but if I play the macro at 4:35 that it returns 4:35 not 12:08. How does one get around this? Any help would be appreciated
What I am trying to do is use a macro to enter specific information on the current row ie. today's date, the time as at the time of entry etc. The date is easy as I have the macro enter =today() and then go back Copy | Paste Special | Value with the same macro.
What I would like is that the time enters as it is at that particular moment. That is to say that at 12:08 that the cell remains as 12:08 but if I play the macro at 4:35 that it returns 4:35 not 12:08. How does one get around this? Any help would be appreciated