I need some help in finding a macro that will delete a line if the message #N/A appears. Right now I have a macro that will hide a row if it has a zero in it and it loops all the way till it hits "done" would like to add the ability to delete a row with #N/A in it, here is my code for the hide zero macro
Any help would be awesome, thanks!
Please Login or Register to view this content.
Last edited by Paul; 06-09-2009 at 04:31 PM. Reason: Merged post without code tags and last post with code tags.
Firstly, you need to add code tags to your post or else you will get your knuckles rapped.
Edit your post, then click the Advanced button, highlihgt the code, and click thePlease Login or Register to view this content.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
thanks for the code Phil, i tried running it and it gave me an error when i hit the #n/a, I don't know if it makes a difference but i copy and paste special values the data into the cells so that the sheet I have doesn't have to recalculate, do you think that would have any affect on it not working?
What was the error given?
Is the "#N/A" the actual text in the cell, or an Excel error message, or what is displayed after some custom formatting?
Is it "#N/A", "#n/a" or "N/a" ? It may be that the case is wrong, but I can't really help anymore without having a copy of the data, or at least knowing what the 'error' was that you got.
The error says Run Time Error '13': Type Mismatch
the cell contains #N/A as the actual text, but it isn't the error message, it is the error message copied and then pasted as a value
Can you upload an example workbook worksheet of your data?
Okay, i have kind of dumbed down the data but I had to in order to post it. What I want to do is delete any row in column E after row 12 that is either a 0 or an #N/A. The workbook eventually will have about 15,000 lines of data to go through so I will also need to copy and paste the data as values before this starts so that it doesn't have to recalculate every time.
any ideas?
Perhaps something along the lines of the below ?
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks