LinkBack URL
About LinkBacks
hello guys!
I would like to ask how to code if you want to delete all rows with fill color for an entire excel file with several worksheets?
Thanks in advance!
hello guys!
I would like to ask how to code if you want to delete all rows with fill color for an entire excel file with several worksheets?
Thanks in advance!
Yes its possible.
Which is the column which has the fill color and which fill color?
Any worksheet to be excluded from the code?
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]
There is no specific fill color. No worksheet to be excluded.
Rows are to be deleted (not column) and there is no specific place. The places of rows with fill color vary with every worksheet.
The entire row has a fill color which needs to be deleted? So any and all fill colored rows to be deleted?
Yes yes.
Hello moniquem,
Here you go,
Also see the "Please Consider" note at the bottom of this post.
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi, Winon!
Do I need to edit anything? It's not working for my file.
Thanks for the response.
Hello moniquem,
Try the attached WorkBook, and see if you can use the code in your WorkBook.
HTH.
Last edited by Winon; 03-01-2013 at 01:00 PM. Reason: Improved and corrected Sample Workbook
It works! Thanks, Winon! Your help and kindness are very much appreciated. Thanks a lot!
Hello moniquem,
You are welcome.
Glad you could get it to run with your WorkBook.
Thank you for the "Rep".
@ Winon
What happens if a cell is colored white?
Should that not be
???Please Login or Register to view this content.
@ jolivanes,
No, I have tried that, and it does not work. It also clears Data in rows without any color, and leaves behind at least one colored Cell on one or more sheets.
In any case, if a Cell is colored white, it would appear as if it is the same as the background color of the Sheet, which is white. If the OP would change the background color of the sheet, it would require an entirely different approach and Coding.
@ jolivanes,
Sorry, jolivanes!
Please ignore my post above. Your suggestion works fine, I have just "tested" it incorrectly.
@ Winon,
No problem, glad it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks