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 sample code shows how to tell if a cell is merged or not. It can really throw a VBA program for a loop if you are not expecting a merged cell and actually encounter one. The technique in this code will return TRUE if the cell indicated is merged and FALSE if it isn't. | ||
|
| ||
| 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. | ||
|
| ||
| This code demonstrates how to incorporate a graphic into a header (or footer) of a spreadsheet. The code also shows how set the text values for headers if required. In this case it sets the title to be bold and underlined. The font size is also set to 32. Link to video demonstration click here. | ||
|
| ||
| This code demonstrates how to delete duplicate rows in VBA quickly and easily with one instruction. We recommend taking a backup of your sheet before you start because once deleted it is gone! | ||
|
| ||
| Excel often stores the date and time in a cell as a combined field. Many times, we need to separate the date, or the time and this code will do that. Remember that you will need to set the cell format of any receiving cell to match the date/time values you are wanting. Note: the output format for time will be hh.mm.ss displayed as military time. | ||
|
| ||
| This code demonstrates how to test a time value from a value extracted using our SplitDateAndTime example. Also, there are two additional lines of code demonstrating how to drop off the seconds or round to the nearest second. | ||
|
| ||
| This code sample will ask the user for the name of the worksheet that they want to use. If the worksheet doesn't exist, then the code will create it. If the name specified does exist then the sheet is selected. | ||
|
| ||
