If statement to reset all cells back to a value

[BX]

Hi
I'm trying to create an if statement where if the statement is true, the following 5 columns (in the same row)have their values reset to a target value. I can reset the value where I'm writing the if statement, however, I don't know how to create an if statement that if true another cell changes. Any suggestions?
BX

 

[rikrak]

On 2002-09-13 11:42, BX wrote:
Hi
I'm trying to create an if statement where if the statement is true, the following 5 columns (in the same row)have their values reset to a target value. I can reset the value where I'm writing the if statement, however, I don't know how to create an if statement that if true another cell changes. Any suggestions?
BX

Is this what you mean?

if condition = True then
range("your range") = targetvalue
endif
This message was edited by rikrak on 2002-09-13 12:27