Hi and thanks in advance,
Wondering if there is anyway to apply a Substitute formula to a whole column without looping. Replace is not an option as it has a limit of 1024 characters.
Tried this but it just put the full range address in every cell in column A ...
Wondering if there is anyway to apply a Substitute formula to a whole column without looping. Replace is not an option as it has a limit of 1024 characters.
Tried this but it just put the full range address in every cell in column A ...
Code:
Dim x As String
With Range("a1", Range("a" & Rows.Count).End(xlUp))
x = .Address
.Value = WorksheetFunction.Substitute(x, origString, newString)
End With