Macro/VBA to select a set of rows and then highlight them in a color?

[Dariusd7]

I am working on a project to automate some steps. What I cant figure out is the following.
1. How to create a macro that will select a group of rows, and the number of rows can change each time. Will select these rows and then highlight them in Blue.
2. After highlighting these rows it will then find the last row, and insert 5 blank rows between the last row of highlight rows and non highlight rows.

So I have in column A a set of row that either have a 1 in them or 0. they are sorted with all row of 1 together and all rows of 0 together. The number of rows that will start with the number 1 can change each time, so I need a macro/vba that will find all rows in column A that start with 1. and then highlight the entire set of rows in the color blue.

Next it will then find that last row of 1, and the first row of 0 and insert 5 blank rows.

Thanks for your help.. I tried to record a macro only to find out that it will do all these things on the exact same number of rows as was recorded..so that wont do since the number of rows could change... Also found out that the conditional formating does not work as a macro..so need to create vba code that can do it..

[judgeh59]

here is a quick and dirty way to do this....

Please Login or Register  to view this content.

Record macro is really cool, you have to learn how to make it dynamic after you record it....this might help....

[jolivanes]

Or as an alternative, you could try this.

Please Login or Register  to view this content.