Replace any value in cell with another using VBA

[K1600]

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......

        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.

 

[steve the fish]

Use a wildcard "*". Be careful to save workbook before you run it in case it doesnt do what you want.

 

[K1600]

Use a wildcard "*". Be careful to save workbook before you run it in case it doesnt do what you want.

I hate technology sometimes. I had tried that already and it didn't work but I've just tried it again and it has.... ?‍

Thanks for the help.