Excel VBA Tutorials

VBA Routine to Sort Sheets

Wednesday, November 5th, 2008 at 18:21 | 2 comments
Categories: Worksheets

VBA Routine to return Column Letter of Cell

Tuesday, November 4th, 2008 at 04:27 | 17 comments

VBA: Extract Number From String

Monday, November 3rd, 2008 at 16:16 | 3 comments
Categories: Strings

Find the nth Word in a String

Friday, October 31st, 2008 at 15:54 | 2 comments
Categories: Strings
Tags: ,

Adding and Naming Sheets to Excel Workbook

Tuesday, October 28th, 2008 at 20:44 | 1 comment
Categories: VBA

Adding and Saving Workbooks

Monday, October 27th, 2008 at 18:16 | 2 comments
Categories: VBA
Tags:

VBA Function to Show Cell Formula

Friday, October 24th, 2008 at 12:58 | 0 comments
Tags: ,

Convert Matrix to Vector

Tuesday, October 21st, 2008 at 12:09 | 3 comments
Categories: VBA

Converting a Single Row Vector into a Matrix

Saturday, October 18th, 2008 at 08:53 | 6 comments
Categories: VBA

Finding the Maximum Value in Each Column in a Range

Thursday, October 16th, 2008 at 15:35 | 0 comments