Deleting #N/A

's Computer Specifications

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

's Computer Specifications

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

--
Gary''s Student - gsnu200738

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Errors deleting email: Unknown error and very slow deleting messag	Keith Rainey	Microsoft Outlook Discussion	0	29th Apr 2010 03:53 AM
Deleting task without deleting e-mail; message views	ideaman	Microsoft Outlook Discussion	1	30th Sep 2009 03:34 AM
Deleting email in Outlook 2007 not deleting on Blackberry 8830 wir	Jennifer L.	Microsoft Outlook Discussion	0	17th Mar 2008 02:29 AM
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content	rmaloy	Microsoft Excel Programming	5	9th Feb 2004 01:59 AM
Deleting or Manually Deleting Programs from the Add/Uninstall Program list	Amy Bejm	Windows XP Basics	3	21st Dec 2003 06:34 AM