Selection Archives - Struggling To Excel

Mix And Match – Get all possible permutations of an unlimited number of lists in Excel

By Ejaz February 21, 2014Macros39 Comments

This post is a little fun, not much of a Struggle I guess. In excel, we use permutations more often than we realize. Say you have twenty performance metrics and you’d like to monitor them for each month, imagine how much copy pasting and concatenating would need being done to get your column header names in place?

Select Similar Coloured Cells in a Range

By Ejaz November 21, 2013Macros2 Comments

If you’d like to loop through all the cells in a sheet, it is very tempting to use something like the following:

Sub LoopThroughCells()

Dim rngCell As Range
For Each rngCell In Excel.ActiveSheet.Cells
	'Type your code here
Next rngCell

End Sub