Excel 2007/2010 – Select all cells with content (VBA)

Scenario

I need to select all the cells in my worksheet which have content.

Effectively selecting from A1 to the last cell in the last row , 
whichever it happens to be..

Solution

Range("A1").CurrentRegion.Select