sujittalukde
12-26-2007, 11:05 PM
I am usding the following code to insert a row between two rows. These two rows have bold font. I wnat to insert rows between two rows and also want to keep the font of nwely inserted rows as regular font ie without bold. THis code keeps the bold off when the row is inserted. But as soon as a text data is written on the cell , it is converted to bold.
Suppose A7 and A8 is bold font cells. NOw I am inserting a row at A8 with this code. Bold for A8 is kept off with this code but as soon as a data is entered in A8 it is converting to bold which I wnat to keep normal ie without bold.
Sub insertrow()
ActiveCell.EntireRow.Insert
ActiveCell.Font.Bold = False
ActiveCell.Select
ActiveCell.Font.Bold = False
End Sub
Why is this happening? How to correct this?
Suppose A7 and A8 is bold font cells. NOw I am inserting a row at A8 with this code. Bold for A8 is kept off with this code but as soon as a data is entered in A8 it is converting to bold which I wnat to keep normal ie without bold.
Sub insertrow()
ActiveCell.EntireRow.Insert
ActiveCell.Font.Bold = False
ActiveCell.Select
ActiveCell.Font.Bold = False
End Sub
Why is this happening? How to correct this?