Used Range Archives - Struggling To Excel

Range Navigator – Smarter Navigation for Excel

By Ejaz January 25, 2014Applications1 Comment

My previous Excel Navigation add-in fetched a few fans; I got a lot of positive feedback on LinkedIn. I designed it to help people working on enormous spreadsheets. I then realized that big workbooks usually host many sheets. I received a few requests to add worksheet selection functionality into the form. Nothing makes me happier than to help my fellow strugglers, so I worked on an extension.

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