XLA Routines: EE_ReplaceErrors
Replaces the errors on a sheet
Sub EE_ReplaceErrors(Optional rng As Range, Optional ReplaceWith As String) 'http://excelexperts.com/xla-routines-eeReplaceErrors for updates on this sub routine ' takes a range and replace the errors in the range Set rng = EE_TableDefault(rng) On Error Resume Next rng.SpecialCells(xlCellTypeFormulas, 16).value = ReplaceWith rng.SpecialCells(xlCellTypeConstants, 16).value = ReplaceWith Err.Clear: On Error GoTo 0: On Error GoTo -1 End Sub
»
- Nick's blog
- Login or register to post comments
- 22865 reads
Recent comments
5 years 20 weeks ago
6 years 6 weeks ago
6 years 17 weeks ago
6 years 20 weeks ago
6 years 21 weeks ago
6 years 27 weeks ago
6 years 35 weeks ago
6 years 35 weeks ago
6 years 35 weeks ago
6 years 35 weeks ago