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

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

HIS
www.nickhodge.co.uk

"Sam" wrote in message
oups.com...
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

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

Thank you!

Sam

Nick Hodge wrote:
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

HIS
www.nickhodge.co.uk

"Sam" wrote in message
oups.com...
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