Here is a list of Excel VBA sample code that we are making available for people to download and use.
The code linked to by this page remain the copyrighted material of
Abbydale Systems. You are free to use the material but please honor the copyrights.
As always you are free to use this code but the usual
disclaimers apply.
By downloading code from this page you agree to the terms of the disclaimer.
These code snippets are used without issue in many of our Excel spreadsheets, however,
we are not releasing the entire spreadsheets where they are used due to
propriety and confidentiality issues.
| Name |
Description | |
|---|---|---|
| This code demonstrates how to add a trend chart to a worksheet in VBA. Link to information page click here. | ||
|
| ||
| This code demonstrates how to compare two dates that have been entered as stings (i.e. 12/25/1999). Link to information page click here. | ||
|
| ||
| This code will return a count of how many rows are non-blank within a specified range. Link to information page click here. | ||
|
| ||
| This code demonstrates how to disable and re-enable Excel functions like Screen Updating etc. Link to information page click here. | ||
|
| ||
| This code will drop the first word from a text string. Link to information page click here. | ||
|
| ||
| This code shows how to get rid of #DIV/0! errors that occur when a cell is empty or contains a 0 (zero). Please follow the link below to see how to eliminate these errors without using VB. Link to information page click here. | ||
|
| ||
| This code sample demonstrates how to access all the files in a Windows folder. Link to information page click here. | ||
|
| ||
| This code will obtain the last word in a string. Link to information page click here. | ||
|
| ||
| This sample code shows how to tell if a cell is merged or not. Link to information page click here. | ||
|
| ||
| This code will tell you the last date of a particular day of the week. i.e. When was the last Friday? It will return the actual date that the day occurred. Link to information page click here. | ||
|
| ||
