Excel VBA Tutorials

How to Create a Bar Chart using VBA

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

Deleting Rows that meet a Certain Criteria

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

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

VBA: Excel’s Colour Scheme

Tuesday, September 30th, 2008 at 14:47 | 0 comments
Categories: VBA

VBA and Vlookup: Find occurence of string

Tuesday, September 30th, 2008 at 14:40 | 1 comment
Categories: LOOKUP, VBA

Interacting between VBA and Excel – Functions

Tuesday, September 30th, 2008 at 14:31 | 0 comments
Categories: Charts, VBA