Archive for September, 2008

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

VBA Function: Populating a Range

Friday, September 26th, 2008 at 11:06 | 2 comments

VBA Function to Compare Dates

Friday, September 26th, 2008 at 11:03 | 0 comments
Categories: VBA

Averaging Non-Zero Values

Friday, September 26th, 2008 at 11:00 | 0 comments
Categories: Formulas

Dealing with NA() Errors

Saturday, September 20th, 2008 at 08:30 | 3 comments
Categories: General
Tags: ,

Using Dynamic Ranges – Year to Date Values

Saturday, September 20th, 2008 at 08:25 | 1 comment
Categories: Formulas

VBA Function To Calculate Number of Words in a String

Saturday, September 20th, 2008 at 08:19 | 1 comment
Categories: Strings

VBA: List of all files contained within a Directory

Saturday, September 13th, 2008 at 18:05 | 3 comments
Categories: VBA