Hi there,

Maybe you're looking for something like this ...


Sub MacroConditionalRun()
Dim rngFind As Range
Set rngFind = Range("A:A").Find("No Error", MatchCase:=True)
If Not rngFind Is Nothing Then
'...
'run macro here
'...
End If
End Sub


Change the column (from A) to that of desired column to look in.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"BDANIELLS" wrote in message
...
This is what I am trying to do.

I want an "if" & "then" statement to be inserted in macro (recording) that
looks at a particular column and sees if the text "No Error" is present in
it. If there is anything in that particular column apart from "No Error" ,
the macro should NOT run at all.

So, just to clarify the above, if there is anything besides "No Error" in
that column, the macro should NOT run, otherwise run successfully.

Thanks so much