Excel VSTO set selection

Question

How do I set the selection in the active worksheet to a specific Range, using C# and VSTO 2008?

Answer 1

You can also use

currentCells.Activate();

Answer 2

Range currentCells = activeSheet.get_Range("A1", "E1"); 
currentCells.Select();