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
Thanks
What is the VBA code to scan a sheet and replace all occurences with a specific value.
I tried the following, to no avail
Code:
Sheets("Emp_Availability").Select
Cells.Replace What:="#REF!", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Thanks