selecting the current row in a for each cell

[bopsgtir]

Ok so this is my code so far, i've tested it to change just one cell but want to apply the rule to the whole row, well actually it would be better to apply to the row upto column CA, but when i use the entirerow it doesnt know what row im talking about. how do i say the row your looking at??

Please Login or Register  to view this content.

[Colin Legg]

how do i say the row your looking at??

It would be

Please Login or Register  to view this content.

You could do this using the autofilter instead of looping, but we'll put that on the back burner for now because you're doing very well by learning through your current approach.

[bopsgtir]

ahhh. so simple, thank you works fine now.