deleting rows macro

F

fullymooned

I have around 3000 rows of data
If the background color of the cell in Col B is light blue (in th
color palette, col 7 , row 4) , then it should delete the row

thank yo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
convert columns to rows 6
delete rows that have a duplicate id keeping the upper row 6
Sheet Cleanup Help Please 5
Excel Heiarchy and Highlight rows where certain data lies 3
Help! Can’t debug macro used to delete duplicate rows 2
Help! complicated programming visual basic 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15

Top