I’ve been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there’s a lack of documentation… no-one knows the passwords. Is there a way of removing or cracking the password on a VBA project? 24 s 24 You can try this direct VBA approach which doesn’t require … Read more
I’ve heard much about the understandable abhorrence of using .Select in Excel VBA, but I am unsure of how to avoid using it. I am finding that my code would be more re-usable if I were able to use variables instead of Select functions. However, I am not sure how to refer to things (like … Read more
How can I use regular expressions in Excel and take advantage of Excel’s powerful grid-like setup for data manipulation? In-cell function to return a matched pattern or replaced value in a string. Sub to loop through a column of data and extract matches to adjacent cells. What setup is necessary? What are Excel’s special characters … Read more
