Hi All,
I am using the formula now() to put the date and time in a cell during a macro. Each day I run a new worksheet and save it, I went into yesterdays sheet and the now() dates times have all changed to literally now when I entered the spreadsheet. Is there anyway I can lock this time / date value, or does anybody know of a more sensible formula to use?
Many Thanks
I am using the formula now() to put the date and time in a cell during a macro. Each day I run a new worksheet and save it, I went into yesterdays sheet and the now() dates times have all changed to literally now when I entered the spreadsheet. Is there anyway I can lock this time / date value, or does anybody know of a more sensible formula to use?
Many Thanks