Current Region Archives - Struggling To Excel

Local trumps Global – Local Named Ranges make the spreadsheet more tractable

By Ejaz January 21, 2014Macros, Tips and Tricks3 Comments

Creating user friendly spreadsheets is not just a professional courtesy anymore. We have the obligation to help users decipher the spreadsheet we so hastily put together. Spending a little extra time setting up well designed spreadsheets help a firm reduce future costs by

reducing the time spent on testing and scrutinizing the sheet.
improving the productivity of the worker.
helping the ‘new guy’ figure out the sheet in no time.
increasing the visibility of errors, consequently reducing the need for rework.

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