Archive for October, 2008

How to Create a Bar Chart using VBA

Wednesday, October 15th, 2008 at 02:15 | 2 comments
Categories: Charts, VBA
Tags: , ,

How to Add a Comment to a Formula

Wednesday, October 15th, 2008 at 02:08 | 4 comments
Categories: Data, Formulas, General

Deleting Rows that meet a Certain Criteria

Tuesday, October 14th, 2008 at 22:50 | 0 comments

Comparing Items in a List

Tuesday, October 14th, 2008 at 02:57 | 1 comment
Categories: Formulas

VBA: Highlight Duplicates in a Range

Monday, October 13th, 2008 at 14:05 | 0 comments

VBA Routine to Add and Name Worksheets

Saturday, October 11th, 2008 at 11:56 | 1 comment
Categories: Worksheets

VBA: User Defined Function that Counts Selected Cells

Saturday, October 4th, 2008 at 10:51 | 0 comments

VBA: Calculate Acronyms from Strings

Saturday, October 4th, 2008 at 10:45 | 1 comment
Categories: Strings

VBA: UDF to perform a 3-parameter Vlookup

Saturday, October 4th, 2008 at 10:36 | 4 comments
Categories: LOOKUP, VBA

Advanced Dynamic Ranges

Saturday, October 4th, 2008 at 10:32 | 1 comment
Categories: Formulas