Slaycock, I must go read about the Immediate If Sounds cool. I suspect I can understand that after reading.

The part I don't get is the condition using Range. I want it to test like this:
If Paragraph 6 has Washington then do something1
Else If Paragraph 6 has Kansas City then do something2
Else If Paragraph 6 has NRCS then do something3
Else If Paragraph 6 has FSA then do something4
Else If Pafagraph 6 has St Louis then do something6
Else do something7