Entire row to be unbolded

[dpaton05]

What is the vba to make an entire row not bold?

 

[Rick Rothstein]

What is the vba to make an entire row not bold?

Let's assume you wanted to unbold Row 6 (change the number as appropriate)...

Rows(6).Font.Bold = False

 

[lrobbo314]

Replace '23' with whatever row you like.

Sub unBold()
Rows(23).Font.Bold = False
End Sub

 

[vcoolio]

Hello DPaton05,

Another option, in case you have a number of rows to "unbold":-

Sub NoBold()

With Sheet1.UsedRange.Offset(1) '----> Change sheet code to suit.
      .EntireRow.Font.Bold = False
End With

End Sub

I hope that this helps.

Cheerio,
vcoolio.

 

[dpaton05]

thanks guys

 

[vcoolio]

You're welcome DP.

Cheerio,
vcoolio.