I'm trying to figure out a way for a macro to search row by row. It will check columns C, D, and E to see if the row below it has the same values. If row 2 has the same values as row 1 then it will check columns a and b in row 2 to see if it is empty. If it is empty then the entire row 1 will be highlighted and row 2 will be deleted. This macro will continue until the program finds 4 empty rows in a row. Any help is greatly appreciated.
is this different from your previous post?
http://www.excelforum.com/excel-prog...whole-row.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Whoops wrong site.
Sooooo you are cross-posting without posting the link too?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks