Name
|
Description |
| | |
| 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) without having to break them down into years, months etc.
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.
It is often advisable to disable Excel's autocalculate and other events for the duration of your program's execution in order to stop a user's screen from changing while code executes. |
|
| DIV0 | This single line of code shows how to get rid of those pesky #DIV/0! errors that occur when a cell is empty or contains a 0 (zero).
By doing this you don't get to see the #DIV/0 error and the spreadsheet looks a lot cleaner. |
|
| DropFirstWord | This code will drop the first word from a text string.
There may be several different ways of performing the same function but this one works just fine. |
|
| 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. |
|
| FormatHoursToHoursAndMinutes | Demonstrates how to convert a field that contains just a total of minutes into hours and minutes. |
|
| GetAllFilesInFolder | The code here demonstrates how to process all the files within a particular selected directory.
The files listed can be filtered by changing the file selection criteria. |
|
| GetLastWord | This sample code shows how to get the last word of a string.
We understand that there are many ways of achieving this but we use this way as it does not require hard coding length, numbers of words etc. and can be done in one line. |
|
