Hi...the code below works fine, but how do I change it so that it
doesn't look for a blank cell (""), but looks for specific text in a
cell? There is an If formula in cell C269 so that if 2 figures balance
then this cell displays "TRUE", otherwise it displays "FALSE".

The code mustn't run if Cell C269 displays "FALSE".

If [C269] = "" Then
MsgBox "The figures don't balance!!"
Exit Sub
End If
Range("E1:E48").Select
Selection.Copy
End Sub

Thanks.

Rob