If statement to reset all cells back to a value

BX

Board Regular
Joined
Jun 2, 2002
Messages
172
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

rikrak

Active Member
Joined
Aug 21, 2002
Messages
255
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,333
Members
412,717
Latest member
EVENTCATERING
Top