Macro to find value "PAA X" but not "Delete Item 14 on PAA X"

[painterartist]

Hi Excelers -

I am working on part of a macro that has me stumped. I need a macro that will search a range of cells for the value "PAA X". (In all cases "X" will be a number from 1-999.) Then when it finds that text I need it to turn the cell bold. Figured that out OK. My problem lies in the fact that some cells contain values like "Delete Item X on PAA X". I want it to ignore any cell that doesn't just say "PAA X".

Specfically, my macro searches cells D90:D1199. If it happens to run into a header called "PAA 142" in cell D95, I want it to bold cell D95. But if it runs into any other text I want it to do nothing - even if the text is something like "Delete Item 450 on PAA 142".

Thanks for reading & responding - this is a wonderful forum & SOOOO educational!!

[tlafferty]

Please post your code and I'll modify it.

Mostly what I'll be doing is looking to see if the left 4 digits are PAA and a space. I will then look at the right digits (length of string - 4) to see if it's numeric. If so, I will apply bolding.

[Leith Ross]

Hello painterartist,

This macro will bold any cell in the range "D90:D1190" of the active sheet if the cell equals "PAA 142".

Please Login or Register  to view this content.

[tlafferty]

To borrow from Leith above, this code will work according to your specs:
That is it will bold anything starting with PAA and ending in a number.

Please Login or Register  to view this content.

[painterartist]

Thanks all for the replies! I am learning alot. I would love to post my code tlafferty & try the wonderful suggestions but the file server is down at the moment so I can't access it. I will try these as soon as possible & TRUELY appreciate the input!

[painterartist]

The file server came back up & tlafferty I used your solution. It worked like a charm. You are fantastic! Big thanks also to Leith as I learned something new from you too! I am going to use the scale to kiss your reputations, but I don't suppose either of you could tell me where to go to mark this post as solved?

[tlafferty]

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[painterartist]

thanks again for everything