I have a replace function in a MACRo that works but would like to use Substitute. Can someone review and update to use Substitute?

Question

Range(Cells(2, 11), Cells(lastRow, lastCol)).Select ' Starting in row 2 and starting 11 rows over the H will be removed in any columns and rows after that through the end of those columns and rows
Err.Clear
tmpErr = Err.Number
On Error Resume Next
Selection.Replace What:="h", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
tmpErr = Err.Number
On Error GoTo 0

Answer 1

Did you try this method?

Dim cell As Range
For Each cell In Range(Cells(2, 11), Cells(lastRow, lastCol))
    cell.Value = Application.WorksheetFunction.Substitute(cell.Value, "h", "")
Next cell