LinkBack URL
About LinkBacks
I have have a worksheet where one column is red (fill color).
I cannot figure out a macro to delete entire rows in the sheet if the fill color in column C is red?
Any Suggestions?
I have have a worksheet where one column is red (fill color).
I cannot figure out a macro to delete entire rows in the sheet if the fill color in column C is red?
Any Suggestions?
Last edited by TheTalentedMrRipley; 11-04-2010 at 07:34 PM.
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
What makes the cell turn red? Are you using Conditional Formatting based on a cell value?
If so, code for automating a filter and deleting visible rows could be written. It is much faster than looping.
Example:
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
This works in a pretty fabulous way. I appreciate the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks