I am trying to insert a new row into a worksheet, but after inserting the row,
I want to change the new Row Interior.ColorIndex = 0 for Columns H to S only.
I don't want to change the rest of the formatting.
How do I code this so that I don't change the rest of that Row.
This is how I'm inserting my new row.
ActiveCell.Offset(1).EntireRow.Insert