Hi there - does anyone know how i can change the formula below to look at specific rows instead please?
Say for example - i wanted to look at rows 5 to 24
Say for example - i wanted to look at rows 5 to 24
Code:
Intersect(Rows(c.Row), Range("F:F,J:J,H:H,L:L,N;N,Q:Q,R:R,S:S")).NumberFormat = myFormat