VBA to highlight an inserted row

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?

Please Login or Register  to view this content.

Cheers,
Keith

Hi Sixthsense,

Thank you for a very quick response and your suggestion.

I copied & pasted the code and ran it, It probably did do what I asked for, but, unfortunately it didn’t do what I wanted.

The code inserted the row in the correct place but then highlighted the row below the inserted row.

I played round with the code after you enlightened me and came up with the code below that I now have working.

Please Login or Register  to view this content.

Thank you for you input.

Keith