Category: VBA

Excel VBA Tips and Tutorials.
Excel Macro How to’s.

Excel Trim Function Doesn’t Work

On many occasions, Excel trim function doesn’t work when trying to trim numbers pasted into Excel. It can be very frustrating to manually delete all...

Insert Hyperlinks from Text (VBA)

When you need to insert a series of hyperlinks into an excel sheet from a list of links, this small macro named “insert hyperlinks from...

Word Cloud Generator

Seeing word clouds (or tag clouds) in dashboards and web sites quite often, I decided to make one myself using Excel VBA. It is a...

For Each Loop (Excel VBA)

For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...

Select Case (Excel VBA)

Select Case Statement lets you execute several group of statements based on value of an expression. It works like CHOOSE Function in Excel.