VBA Problem with code

[ryan_law2000]

Im having come major problem making this code work
This is part of what I have

If Not Intersect(Range("B5:B5000"), Target) Is Nothing Then

right after this code put something like this...

in range (B5:B5000) if cell = "CSTS Attached" then do not run (or goto end sub)

it almost sounds too easy, but it could work

Basically when i click on a cell within B5:B5000 it will run the rest of the code UNLESS the cell = "CSTS ATTACHED"

Can Anyone Please Help

 

[Jonmo1]

If Target.Value = "CSTS ATTACHED" Then Exit Sub

HTH

 

[ryan_law2000]

WORKS PERFECT!!!!
Thank you so much Jonmo1