Forum Discussion

werner77's avatar
werner77
Copper Contributor
Dec 01, 2021
Solved

Macro to add column with date that doesn't automatically update.

I have been assigned a task of adding a button(macro) that adds a column on a sheet with todays date on it.  Which I have so far accomplished, but I need to not update all the field previously genera...
  • HansVogelaar's avatar
    Dec 01, 2021

    werner77 

    Change the line

        ActiveCell.FormulaR1C1 = "=today()"

    to

        ActiveCell.Value = Date

Resources