replace 0w by null

[hktom]

Dear all

Attached with file, the column a(sheet1) after vba code
Should same as column a(sheet2).

That is: the code should replace 0w by null
But the code don’t work

Pls help

Tks
Tom

[Marc L]

Like explained in VBA help so as a very beginner starter :

Sub Demo1()
    Sheet1.Cells(1).CurrentRegion.Replace "w", "", xlWhole, , True
End Sub 

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[ikboy]

Sub Replace()

'LastRow = Cells(Rows.Count, 1).End(xlUp).Row
'For i = 1 To LastRow
    
 'Columns("a:a").Select
 Columns("a:a").Replace What:="w", Replacement:="", LookAt:=xlWhole, _
 SearchOrder:=xlByColumns, MatchCase:=True, SearchFormat:=False, _
 ReplaceFormat:=False
 
 
End Sub

[hktom]

Thanks All, That work perfect