Name
|
Description |
| | |
Abbydale Systems LLC. - Because IT matters
| AddTrendChart | This code demonstrates how to add a trend chart to a worksheet in VBA.
Link to information page click here. |
|
| CompareDates | 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. |
|
| CountNonBlankRows | This code will return a count of how many rows are non-blank within a specified range.
Link to information page click here. |
|
| DisableEnable | This code demonstrates how to disable and re-enable Excel functions like Screen Updating etc.
Link to information page click here. |
|
| DropFirstWord | This code will drop the first word from a text string.
Link to information page click here. |
|
| EliminateDivideError | 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. |
|
| GetAllFilesInFolder | This code sample demonstrates how to access all the files in a Windows folder.
Link to information page click here. |
|
| GetLastWord | This code will obtain the last word in a string.
Link to information page click here. |
|
| IsItMerged | This sample code shows how to tell if a cell is merged or not.
Link to information page click here. |
|
| LastDayOfWeek | 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. |
|
