Deleting Rows If Not Bold

  • Thread starter Thread starter Bob Beard
  • Start date Start date
B

Bob Beard

I require a row deleting if the cells in columns D and E
are NOT bold.

is this possible?

Excel 2000.

Thanks

Bob.
 
Hi Bob
For i = Range("E65536").End(xlUp).Row To 1 Step -1
If Not Cells(i, 4).Font.Bold And Not Cells(i, 5).Font.Bold Then Cells(i,
4).EntireRow.Delete
Next i

HTH
Cordially
Pascal
 
You must log in or register to reply here.

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

Word Removing unwanted "lines" within a MS Word 10 table 1
Removing unwanted "lines" within a MS Word 10 table 2
Concantenate which keeps bold of some parts. 5
If, then bold row 4
Bold rectangle cursor in VB Editor 3
Alphabetically list of last names: BOLD, not bold 16
Alphabetically list of names BOLD and NOT bold 13
Excel 2003: Keeps applying auto-font settings I don't want 1

Back
Top