ExcelBanter - Deleting #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Deleting #N/A (https://www.excelbanter.com/excel-programming/395773-deleting-n.html)

Deleting #N/A

hi, can someone tell me a procedure to delete #N/A from within a large
range?

Gary''s Student

Deleting #N/A

Sub inams()
For Each r In Selection
If r.Text = "#N/A" Then
r.Clear
End If
Next
End Sub

--
Gary''s Student - gsnu200738

All times are GMT +1. The time now is 07:48 PM.