Howdy!

I have probably a simple problem to solve but I have been around in circles and not getting anywhere!
Basically I have a column M ("Reject" - values are 0 or 1) and another column R called "Status". I would like a command button to scroll through each row and where Col M = "1" the code will check what is in Col R and write "Cancelled".

So where cell in Col M = "1" then cell in Col R = "Cancelled"

I have been able to get this working (sort of) but individual cells, but fail each time I try to get it to work on the entire data range

any help is appreciated!!!

thanks
Harvi