In the VBA editor, go to View, Toolbars, Customise… or right click on the tool bar and select Customise… Under the Commands tab, select the Edit menu on the left. Then approximately two thirds of the way down there’s two icons, Comment Block and Uncomment Block. Drag and drop these onto your toolbar and then … Read more
You can try this direct VBA approach which doesn’t require HEX editing. It will work for any files (*.xls, *.xlsm, *.xlam …). Tested and works on: Excel 2007 Excel 2010 Excel 2013 – 32 bit version Excel 2016 – 32 bit version Looking for 64 bit version? See this answer How it works I will … Read more
Some examples of how to avoid select Use Dim‘d variables Dim rng as Range Set the variable to the required range. There are many ways to refer to a single-cell range: Set rng = Range(“A1”) Set rng = Cells(1, 1) Set rng = Range(“NamedRange”) Or a multi-cell range: Set rng = Range(“A1:B10”) Set rng = … Read more
Regular expressions are used for Pattern Matching. To use in Excel follow these steps: Step 1: Add VBA reference to “Microsoft VBScript Regular Expressions 5.5” Select “Developer” tab (I don’t have this tab what do I do?) Select “Visual Basic” icon from ‘Code’ ribbon section In “Microsoft Visual Basic for Applications” window select “Tools” from … Read more