Hi Guys

Below is some code I am trying to complete but ot does not ALL work.

I am inserting a row and I want the row to be highlighted.

The insert part is working ok but not the highlight part.

Can someone please help?


With Workbooks("KeithSilver Dawn Income.xlsm").Sheets(Sheet_No)
                rw = rw + 1
                .Rows(rw).Insert
                .EntireRow.Interior.ColorIndex = 27
            End With

Cheers,
Keith