Deleting #NA in a Spreadsheet
Try this small macro:
Sub nakiller()
Set rna = Nothing
For Each r In ActiveSheet.UsedRange
If r.Text = "#N/A" Then
If rna Is Nothing Then
Set rna = r
Else
Set rna = Union(r, rna)
End If
End If
Next
rna.Clear
End Sub
--
Gary''s Student - gsnu200810
"Confused_in_Houston" wrote:
I run vlookups and get a large number of #NA responses. I know in a single
column, I can sort by the vlookup column, group the #NA's; highlight and
delete.
However, some spreadsheets have 10 or more columns of vlookups, so I've got
#NA's all over the page. Rather than do ten sorts, I'd like to find a way to
delete all #NA's at the same time.
I've tried the Replace function but it doesn't connect my #NA with the #NA's
on the spreadsheet.
Thanks. I always appreciate the help I get here.
|