Category: VBA
4 Ways to Remove Unwanted Space Characters
Learn how to remove unwanted space characters from text data in Excel using various methods.
Read More
How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets
It’s often the case that workbooks get very large and end up with a lot of sheets. Excel...
Read More
How to Create Delete and Rename Folders from a List
I started making videos to go along with my post on pivot tables called 101 Advanced Pivot Table...
Read More
How To Export Your Data Into Separate Workbooks Based On The Values In A Column
Something that comes up time and time again in any kind of work is separating data out into...
Read More
How To Check If A Worksheet Exists Using VBA
There may come a time when you need to know if a sheet in a workbook exists either during VBA code...
Read More
How To Find The Nth Item In A Comma Separated List
Let’s say you have a column of data and in each cell you have a text string which is a list...
Read More
