I need to loop through a range of cells - Range("AH2", Range("AH65536").End(xlUp)) - and if a certain value is found another value needs to be placed in the cell directly to the right .

I was thinking that Select Case would be the simplest method, but how do i loop through the Range in AH2 and how do I place a value in the cell to the right?

Thanks in advance for any and all help!