I am using a replace loop to change certain words.
The challenge I have is with dates. The dates are reported as follows: 20/08/2020. It could be any day of the month but I need to replace it with AUG20. For September dates that would be SEP20.
Thank you.
VBA Code:
Dim oRange As Range
For Each oRange In ActiveSheet.Range("A1:A10000")
oRange.Replace What:="AssetName", Replacement:="Commodity", MatchCase:=False
Next
The challenge I have is with dates. The dates are reported as follows: 20/08/2020. It could be any day of the month but I need to replace it with AUG20. For September dates that would be SEP20.
Thank you.