Highlighting an Entire Range, then wanting a particular active cell

[CR2515]

Say I select columns A through G all the way down, then I want my cursor and active cell to be in D1.

How can I keep my range selected but get over to active cell D1?

Thanks.

 

[wideboydixon]

In VBA:

Columns("A:G").Select
Range("D1").Activate

WBD

 

[CR2515]

New to Excel can you walk me through it?

 

[wideboydixon]

Press Alt+F11 to bring up the VBA editor. Select Insert>Module and paste the following code into the new module:

Public Sub HighlightRangeActivateCell()
    Columns("A:G").Select
    Range("D1").Activate
End Sub

Now close the VBA editor and back on your sheet press Alt+F8 to bring up the list of macros. Select "HighlighRangeActivateCell" and run it.

WBD

 

[CR2515]

Thanks. Also found I could highlight a range and scroll through headers and individual cells using the TAB key thereafter.