New Create a new chart
A quick and easy way to create a new chart
Continue reading this article ›
Calculating the number of working hours between two dates
Note that the “Holidates” should actually be removed from the routine and a table should be devloped to replace them.
Continue reading this article ›
GoTo statement and error handling
The example contains the following elements: an On Error statement (On Error GoTo ErrorHandler) and a Resume statement. The error handler might contain an Error Statement and/or an Error function.
Continue reading this article ›
Get web titles and URLs from all open IE browsers
List Webpage Title and URL’s in Excel
Continue reading this article ›
Find the Max value in a row, return the column header
Find the colun that has the highest numeric value
Continue reading this article ›
Counting unique values
Let me count the ways…
Continue reading this article ›
Filtering Data in Excel
The following code fragment filters and sorts data on a specified column
Continue reading this article ›
VB Constants in Text Strings
VB constants that can be used in macro code to insert certain formatting characters, such as tabs, line feeds, and carriage returns.
Continue reading this article ›
Sort the worksheets in a workbook
The following macro will sort all the worksheets in a workbook in ascending order.
Continue reading this article ›
List files in a folder with Office 97 or later
In Office 97 or later it’s easy to get a list of filenames in a folder, optionally included any subfolders.
Continue reading this article ›
