VBA To Insert A new Row with Specific formatting

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.

Code:

---

ActiveCell.Offset(1).EntireRow.Insert

---

may be

Code:

---

Intersect(Rows(ActiveCell.Offset(1).Row), Range("H:S")).Interior.ColorIndex = 0

---

anish.ms: Thanks
Unfortunately, that did not do the trick.
The code had no effect on the new inserted Row.
I will revisit it later.

Code:

---

    ActiveCell.Offset(1).EntireRow.Insert
    ActiveCell.Offset(1).EntireRow.Cells(1, 8).Resize(1, 12).Interior.ColorIndex = xlColorIndexNone

---

Thanks Paul_Hossler:


I did this clunky code to achieve the results that I was looking for once my brain got switched back on.

Code:

---

ActiveCell.Offset(1).EntireRow.Insert
 Range("H" & ActiveCell.Offset(1, 0).Row & ":S" & ActiveCell.Offset(1, 0).Row).Interior.ColorIndex = 0

---

I will try your code anyway.


Thanks