VBA Macro to impact all worksheets not just sheet1

[PastaPaul]

Hello,

Was working on a problem and found a great little bit of code posted in a different thread (thanks Dave Peterson - http://www.excelforum.com/l/561722-asdf.html).
You can see Dave's code at the bottom my post. It concatenates 2 cells and applies different formatting to the result.

My issues now is that it specifically refers to "Sheet1".
My workbook has 22 worksheets, and I'm wondering if there's a way to run it across multiple sheets (ideally all sheets with a particular prefix) or alternatively on every sheet in the workbook.

Please Login or Register  to view this content.

Thanks for any help... Paul

[MarvinP]

Hi Paul,

Try this:

Please Login or Register  to view this content.

Then PLEASE edit your original post and select your code and click the "#" icon to put Code markers around it so it looks like mine.

[PastaPaul]

Marvin, this is great. Thanks so much.

There's one page on the sheet that is basically a large lookup table.
Is there any easy way to get the macro to ignore that page (called "AllCodes"). If needs be I can insert dummy columns so the data on the lookup table remains intact when the macro runs (or reference it as a separate file), but if it's easy to ignore that sheet that would be great.

Thanks again,
Paul

[MarvinP]

Here ya go...

Please Login or Register  to view this content.