Selection.EntireRow.Insert
ActiveCell.EntireRow.Interior.ColorIndex = 6

Regards,
Stefi

€žSubhojeet€� ezt Ã*rta:

Hello,

I want to write a macro where on inserting a new row in the active
worksheet, the newly inserted row will become yellow in color. But I dont
know how to do this. kindly help

Thanks