IF Statement

[jonnygrim]

Hi,

Is the a function that does:

IF A2-A5="yes" then copy contents of A1-A3?

Thanks

[wmorrison49]

I am a little confused by your phrasing. Are you saying if A2 minus A5 equals "yes" then do something? Or if the word "yes" appears in that range?

[jonnygrim]

Hi sorry,

Its if any column in that range appear with the word yes in it.

Thanks

[wmorrison49]

Here's some code that looks in the range A2:A5 and if there is a "Yes" anywhere in there, copies cells A1:A3 to cells C1:C3.

Range("A2").Select
If ActiveCell = "Yes" Or ActiveCell.Offset(1, 0) = "Yes" Or ActiveCell.Offset(2, 0) = "Yes" Or ActiveCell.Offset(3, 0) = "Yes" Then
Range("A1:A3").Select
Selection.Copy
Range("C1").Select
ActiveSheet.Paste
End If

Hope that's what you were looking for.