From the category archives:

Excel Function

Find as a Function

by Scott Lindsay on June 11, 2010

In our previous post on Find and FindNext we saw that in combination they can be used to search through large amounts of data very quickly.

In many cases we need to use Find and FindNext on a worksheet. The best way to implement repeatable and automated worksheet based functions is through User Defined Function (UDF). This is just a function written in VBA code that can be used on a worksheet.
[click to continue…]

Chart Exists Function

by Scott Lindsay on March 11, 2010

The following Function has been designed to check if a chart already exists in the open workbook. If it does exist then it will return TRUE, if not then the Function will return FALSE. Based on this function your other code can then create the chart if needed or use the existing chart.

[click to continue…]

Is Workbook Open Function

February 27, 2010

The following Function has been designed to check if a workbook you are about to open is already open. If it is then it will return TRUE, if not then the Function will return FALSE and your other Macro code should then open the workbook that is required.

Read the full article →

Excel Function

Find as a Function

Chart Exists Function

Is Workbook Open Function

Categories

Tag Cloud