MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Trun off Bold


Posted by Andonny on June 02, 2001 5:14 PM

Hi,
When the Macro inserts a new line with the code below I need to make it Font.Bold = False because the row above is Bold and it seems to take that to keep it Bold which I don't need.
I tried a few variations but I couldn't do it.

Cells(i, 1).EntireRow.Insert

Thanks for your help
Andonny


Posted by Kevin James on June 02, 2001 9:40 PM

Turn off Bold

Andonny

My Scenario:
I opened a new workbook, and bolded column B.

I used the macro recorder to generate the following code.

Sub Macro1()
Rows("3:3").Select
Selection.Insert Shift:=xlDown
Selection.Font.Bold = False
End Sub

Hope this helps,
Kevin