I have a column with numeric values and #N/A. I am trying to filter for everything except the #N/A and then delete. The following is what I have so far, but it's not working.
Any help is appreciated. Thanks!
Please Login or Register to view this content.
Last edited by arlu1201; 05-18-2012 at 03:59 AM.
Try changing this -toPlease Login or Register to view this content.Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Arlette. But I think that does the opposite of what I want. I want to select all values except the #N/As so I can delete them. I thought putting <> in front would work, but somethings off... Do you have any suggestions for that?
Oops sorry. Then use thisPlease Login or Register to view this content.
How do you do this with a few criterias? For example if I want to select all, except for item1, item2, and item3.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks