mfairbanks
New Member
- Joined
- Sep 12, 2002
- Messages
- 17
I am using VBA to have some cells autofill if they are = No. I set it up, if cell A2 = No then cells B2 through F2 Value will = No.
How can I set this up to work on every row for each time the select No in column A is selected?
Here is the formula:
If Target.Address = "$A$2" Then
If LCase(Target.Value) = "no" Then
Range("$B$2:$F$2").Value = "No"
End If
End If
How can I set this up to work on every row for each time the select No in column A is selected?
Here is the formula:
If Target.Address = "$A$2" Then
If LCase(Target.Value) = "no" Then
Range("$B$2:$F$2").Value = "No"
End If
End If