Excel Add-In To Perform Common Tasks
Category:
Office/VBAType:
ApplicationsDifficulty:
IntermediateAuthor:
Jon CogzellVersion 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