You can copy the code I posted and paste it into your Visual Basic Editor
(VBE) in a Standard Module located in your project (workbook). Shortcut
keys would be ..

Alt + F11 (open VBE)
Ctrl + R (open Project Explorer)
Select file on left
If no modules exist:
Insert | Module
Paste code in Module
If modules exist:
Double click desired module
Paste code in Module
Add code as desired

Is there other code you would like help with here?

--
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
...
Thanks ZACK:

Where do I insert this?

Thanks


"Zack Barresse" wrote:

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