Macro to replace error values
 

I am working on huge spreadsheets in excel. Many cells have error
values. Can anyone suggest a macro that will find all these error
values and replace them with a "." (period)?

Thanks

Macro to replace error values
 

Sub ReplacewithPeriod()
On Error Resume Next
Cells.specialcells(xlFormulas,xlErrors).Value = "."
On Error goto 0
End sub

--
Regards,
Tom Ogilvy


"Shamik" wrote:

I am working on huge spreadsheets in excel. Many cells have error
values. Can anyone suggest a macro that will find all these error
values and replace them with a "." (period)?

Thanks

Macro to replace error values
 

Hi Tom,

Thanks a lot!! This was the very thing I needed.

Shamik Shah

Tom Ogilvy wrote:
Sub ReplacewithPeriod()
On Error Resume Next
Cells.specialcells(xlFormulas,xlErrors).Value = "."
On Error goto 0
End sub

--
Regards,
Tom Ogilvy