Excel VBA Remove Duplicates Multiple Columns

Remove Duplicates from multiple columns in Excel with VBA.

Read More

Excel Create or Remove a Table with VBA

There are times in Excel when you may wish to create a table on the fly with the assistance of VBA code.  I was in this position recently and needed to this with VBA.  A file was uploaded into a sheet and the task was to create a table and then use that table for more data manipulation.  The following Excel VBA procedure was what I ended up with.

Read More