I want to change the next cell in same row in a if cell.value="word" in a range. I have defined the range, using 'for' loop. In my code,
if cell.value="FOUND THE CELL" then cell.value+1="changed the next right side cell" cell.value+2="changed the second right side cell" end if
I know this is wrong. How can we do it?