Formating cells with a Loop

[kevin-m]

Hi,
I've created a macro that checks various cells in 2 columns in one sheet and then formats 2 columns in another. However the rows do not correspond ie row 2 in sheet 2 might correspond to row 2 in sheet1 but row 3 in sheet 2 will correspond to row 4 in sheet1 (due to the cell formatting and page layout in sheet 1.
I need this macro to run on 40 rows max and the obvious thing would be a loop. But I can't think on how to do this.
So is the answer to repeat the code 40 times? And if so, am I better putting the code into seperate modules to keep it tidy with one module leading on to another?

[Domski]

Hi,

If you post a sample workbook it would help us to see if there's a pattern that came be used in the loop or another way of dealing with it.

Dom