I am trying to replace all values in column K in my spreadsheet using VBA with a date 14 days from today. I've tried using find and replace but the value to be replaced could be anything.
I was trying the below code but not sure what to put in the Find:= bit......
Any help would be appreciated.
I was trying the below code but not sure what to put in the Find:= bit......
VBA Code:
sh2.Columns("K").Replace _
what:="***Not sure what to put here***", replacement:=Format(Date + 14, "dd/mm/yyyy"), _
searchorder:=xlByColumns, MatchCase:=True
Any help would be appreciated.