if cell contains

J

JamesBurrows

Does anyone know if there is a way of saying

'deleted is a string

If cell contains deleted, Deleted or DELETED (ie allowing for case
sensitivity)

Not if cell = deleted

i looked at the instr funtion but am not sure how to contruct it for
the three options.

Cheers
 
J

JamesBurrows

Thanks for your help Andy that looks about right. A few issues I hav
with it are: I dont want an error message if it contains the string
meerly want it to do the code below if it is present else, blah bla
blah. and also my cell reference is not A2 it is Worksheets("Lin
List").Cells(LLCurrent, "Y"), but when i put this in it seems to caus
a massive headache.

Any help gratefully appreciated.

Jame
 
Top