runtime error 1004 : Method range of object - 'Global' failed

Mr. Chan

Here I am again, pardon for the bother..

kindly help with the small snippet below

I wish to erase in a range of column the word "Total" in a cell.

in EXCEL it is =left(cellText, len(cellText)-5)

How do I write it in vba?

many many many thanks

Sub RemoveWordTotal()
 
 Application.ScreenUpdating = False
 Dim i As Long
 For i = Cells(Rows.Count, "B").End(xlUp).Row To 2 Step -1
 
 ' remove the word total inside a column range cell
 
 Next i
 
 Application.ScreenUpdating = True

End Sub