Correct #REF using vba macro

[UHsoccer]

I have instances where a #REF! is displayed.

What is the VBA code to scan a sheet and replace all occurences with a specific value.
I tried the following, to no avail

Sheets("Emp_Availability").Select
 
Cells.Replace What:="#REF!", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False

Thanks

 

[jkpieterse]

My code currently only processed the REF error cells (hence the test within the loop for cell value being CVErr(xlErrRef))

 

[vds1]

you could always use Iserror function.

Iserror( expression) as boolean

 

[klarowe]

My code currently only processed the REF error cells (hence the test within the loop for cell value being CVErr(xlErrRef))

Ahhh... I looked through it quick and missed where it listed the ref error specifically. Guess I should learn to read better...