Alright. I've got a general function that takes a pattern as a string and an (optional) name of a workbook. It then looks through all of the sheets in that workbook, and creates an array of the sheets that match that pattern. Basically, it's a sheet searching function. What I'm proud of is its flexibility. What I'm not proud of is its error handling abilities. If something goes wrong, it goes straight to code/compiler errors. If it can't find any sheets, invalid strings, workbook isn't there, etc.
So. I need help improving it's ability to respond to bad situations in a more productive way than spitting errors at me.
What do you think? How can I make this code better?![]()
Please Login or Register to view this content.
Bookmarks