Formula works for one row. But I need it to work with all ro

[mfairbanks]

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

 

[mfairbanks]

The security is medium. It prompts you to enable the macros. Which I click enable macros and assumed that it would work fine?

 

[Andrew Poulsom]

It should work if you enable macros. Can't think why not at the moment.

 

[mfairbanks]

One person has Excel 97 and the other is on 2000. I am using Excel 2000. When I open VB on the one persons computer and select DeBug and compile it. It comes up with the error: Compile error - Can't find project or library. Then the reference window comes up.

 

[Andrew Poulsom]

Perhaps they have a limited custom installation. I think the references dialog box tells you what's missing. You might need to update the installation from CD or whatever.

 

[mfairbanks]

Thank you, you have been helped me out a lot!