What This VBA Code Does Have you ever had to search through a large Excel spreadsheet to find specific text?...
Dealing With SuperScripts/Subscripts Sometimes you receive data or copy data that has superscripts or subscripts that you really don’t want...
What This VBA Code Does In my day job, I often have to add a prefix to thousands of ID...
What This VBA Code Does I have run into a couple of instances recently where I needed to clean up...
What This VBA Code Does The following VBA macro code is something I use all the time to manipulate the...
What This VBA Code Does This VBA macro function will allow you to generate a string of characters at random...
What This VBA Code Does This VBA code will use the power of Regular Expressions to parse through text and...
What This VBA Macro Code Does I found this code snippet on an Ozgrid forum post written by a fellow...
What This VBA Code Does Whether you are wanting to know how many times a double 'S' appears in the...
Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations...
What This VBA Code Does If you want to create multiple lines of text you can either use vbNewLine or...
What This VBA Code Does This VBA macro with let you specify a value and create an Excel range selection...
What This VBA Code Does These VBA macros will show you various ways to find and replace all for any...
Today we are going to discuss how you can use VBA to ensure that cell values match a specific pattern. ...
What This VBA Code Does This bit of VBA code looks at a text string within a specified cell and...
What This VBA Code Does I typically use this kind of functionality if I am trying to compile a list...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!