Want to create VBA for each code to look for cells in i12:i50 and substitute the string Sep with Oct
The string could for instance be: corp sep accrual which should be converted to corp oct accrual
Sub journal()
Dim describ As String
describ = Range("i12:i50")
for each describ
if
End Sub