Auto-Highlight the Active Row When a Cell is Selected

Something different on theSmallman today - actually something different all together. Since starting my Excel website and subsequent blog over 3 and a half years ago I have created over 300 pages from financial modelling to dashboard design to unlocking Excel's scripting dictionary. I have writen every word myself and have drawn extensively on my posts on Ozgrid and Chandoo forums. Today for the first time someone else is going to do the instructing. The two handsome gentleman above are Kasper and Mikel.