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.
Thanks for any help... PaulPlease Login or Register to view this content.
Bookmarks