VBA Zone

THE FREE, OPEN-SOURCE OFFICE PRODUCTIVITY SOLUTIONS & DESIGNS.

A quick and easy way to create a new chart

Continue reading this article ›

Note that the “Holidates” should actually be removed from the routine and a table should be devloped to replace them.

Continue reading this article ›

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 ›

List Webpage Title and URL’s in Excel

Continue reading this article ›

Find the colun that has the highest numeric value

Continue reading this article ›

Let me count the ways…

Continue reading this article ›

The following code fragment filters and sorts data on a specified column

Continue reading this article ›

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 ›

The following macro will sort all the worksheets in a workbook in ascending order.

Continue reading this article ›

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 ›