Solved: Range Select and Delete certain Values

[anthony20069]

Hi peeps,

Was wondering if you are able to do the following in VBA.....

First it must select a range of cells B53:S78, then look in each cell and if the value is "n/a" then it must get deleted... is this possible?

Cheers

Anthony

[mbarron]

This should do it:
Range("B53:S78").Replace what:="n/a", replacement:="", lookat:=xlWhole

[anthony20069]

:thumb :thumb cheers works like a charm