How to insert color in row or cell?

[Sam]

HI all,

Ok so I got the part about inserting a blank row everytime there is a
sequence change in a particular column but.

Then how do I then add color to the inserted row? I just wanna make it
easier for my viewer to see thier data once its broken up.

Thank you,

Sam

 

[Nick Hodge]

Sam

I missed the original solution for inserting the row but whatever you are
using to insert the row, say

Rows(x).Insert

then use

rows(x).interior.color=rgb(255,0,0)

Where x in all cases is the row number and 255,0,0 will give you red

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[Sam]

Thank you Nick, I tweaked with the code to fit my needs and it was
exactly what was needed!

Thank you!

Sam