This feels like it should be so easy but it has befuddled me the past two days. I have a pretty lengthy macro in process that takes a data set in a workbook and splices it into several new tabs that vary in number and name. The last piece I'm trying to conquer to this macro is to find all the tabs with specific text in their names and perform some simple actions on all those tabs only (delete row 1 and columns A-C on each, remove all shading, and then format each sheet entirely as General).
I may or may not be able to use the Dim coding (at least, I got compilation errors when I did) as I have that already in the macro, so as a workaround I tried to make the macro look for the first tab containing the specific text and then doing my required actions on that tab and all that follow (as they are always going to be the final x number of tabs in the workbook), but I can't get that to work, either.
Any insight would be greatly appreciated. I'm not an expert on this, but I'm not totally ridiculous either.
thx much.
Bookmarks