Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Automatically select data-containing cells in Excel

Posted 29th January 2014

No comments

This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.

Read the full story...

Automate the creation or deletion of worksheets in Excel

Posted 24th January 2014

No comments

Use VBA to create or delete worksheets in Microsoft Excel.

Read the full story...

Automatically number rows in Excel

Posted 16th January 2014

No comments

Use a simple Visual Basic for Applications (VBA) script to automate the process of numbering new rows in Microsoft Excel.

Read the full story...

Blog post thumnail

How to enable the Data Analysis toolpak in Excel 2010

Posted 15th February 2013


Instructions for adding the Data Analysis tool pack to Microsoft Excel

Read the full story...