Excel Add-In To Perform Common Tasks

Category:

Office/VBA

Type:

Applications

Difficulty:

Intermediate

Author:

Jon Cogzell

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:

I regularly do common tasks in excel which required some VB(A) code. I decided to write an add-in for them. Tasks the add-in peforms include:

Deleting blank columns
Deleting columns where selected rows are blank
Deleting blank rows
Deleting rows where selected columns are blank
Append running totals to a row or column
Set or change a workbook password
Many more

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download spreadsheet_solutions.zip

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.