LinkBack URL
About LinkBacks
Hi everyone,
Any suggestions on how to delete rows by VBA?
The condition is, If the value on Cell (From D7 to last record) is equal to "#VALUE!"
It will delete the entire row.
Appreciate your help once more. Thank you in advance.
Andrew
Hi everyone,
Any suggestions on how to delete rows by VBA?
The condition is, If the value on Cell (From D7 to last record) is equal to "#VALUE!"
It will delete the entire row.
Appreciate your help once more. Thank you in advance.
Andrew
Last edited by Andrew.Trevayne; 10-13-2011 at 11:07 PM.
when you insert or delete rows start from last row to first row.
as you are tampering with your data sheet better copy sheet1 to sheet 2 as precaution
try this macro
Please Login or Register to view this content.
Venkat,
I do not see the #value condition in the code. The rows have to be deleted based on that condition.
Hi Venkat,
Tried the Script but it doesn't do anything on my spreadsheet. Please advise.
Thank you.
Hi Andrew.Trevayne
Slight modification of venkat1926 code...see if this worksPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Jaslake & Venkat,
Thanks to you both. ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks