When a cell within a cell range is updated I need that cell value then to be overwritten and the value changed to today's date.
I still need to be able to delete that cell and clear it.
The code below doesn't work.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
If Not Intersect(Target, Range("A3:B100")) Is Nothing Then
For Each cell In Target
cell = Format(Date, "MM/DD/YYYY")
Hi, I am good at Excel and vba. I have reviewed the requirement. Please share the file to work on it and correct the program as per the requirement. -Chandra
11 freelancers are bidding on average $9/hour for this job
Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.