Macro to Count Every X amount of Rows

[rjacmuto32]

I have 101 rows of data with row 1 being my header row. I want to do a macro to highlight every 10 rows all the way to the end. So I want rows 11,21,31,etc to be highlighted. How do I do that?

Thanks.

 

[Scott Huish]

Why do you need a macro? Why not use Conditional Formatting?

With Conditional Formatting:

Select your entire range, i.e. A1:IV101

Click on Format, then Conditional Formatting
Under Condition 1, change Cell Value Is to Formula Is and put in the following formula:
=MOD(ROW(),11)=0
Click on Format
Click on Patterns
Select a color
Click OK
Click OK

 

[rjacmuto32]

Forgot to add this

Besides highlighting I would also like to copy column B of every 10th row into a new worksheet. If i conditional format the cells for that, how do i use a macro to copy cell B11,B21,B31 etc.

 

[Scott Huish]

Sorry,

try this formula instead:

=MOD(MAX(ROW(),2)-1,10)=0