Rearrange Excel columns via Visual Basic
Posted 16th March 2016
22 comments
A simple VBA script for rearranging the order of columns in an Excel spreadsheet.
VBA: Convert text to columns for all worksheets in Excel
Posted 26th November 2015
7 comments
A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.
VBA: Delete all Excel columns except those named
Posted 16th September 2015
2 comments
Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.