Excel VBA Revisited

Excel VBA tips and functions

Sunday, October 26, 2014

Subscribe to: Posts (Atom)

EndsWith and StartsWith For VBA

Here are listings for 2 functions that are missing in VBA: string starts with and string ends with. The functions are case-insensitive. They...
Split String By Comma

The following routine splits the comma-separated contents of an active cell into strings and prints each result below the active cell. It w...
(no title)
Add Hyperlinks

The following procedure converts a url to a hyperlink in range: Sub AddHyperlinks(rng As Range ) Dim c As Range For Each c I...
Check if Worksheet Exists

This is a VBA function that checks if a Worksheet exists. It accepts a worksheet name as a parameter. It loops through worksheet names and s...
Some Excel Range Functions

Here I will list code for some useful VBA functions that deal with an Excel range. I think the function descriptions are self-explanatory. ...
Initialize VBA Array

Declare an array as Variant: Dim arr as Variant Use the VBA Array function to initialize the array: arr = Array(154, 155, 156, 157)

Simple theme. Powered by Blogger.