How to navigate back to a cell ?

Nocaster51 · November 24th, 2011, 02:00 PM

I have a Excel 2007 VBA routine which stores the active cell reference using ;

CellLocation = ActiveCell.Address

My routine then goes off and performs various tasks which moves the active range.

After these tasks are complete, I want to navigate back to the original CellLocation.

However, I cant workout the syntax to go back to select the cell contained in "CellLocation"

Can anyone help ?

And should I declare the CellLocation variable as a particular type ?

many thanks in advance,

Shasur · November 26th, 2011, 01:48 AM

Hi

You can try using Select like this

Code:

Dim InitCellLocation as Range
Set InitCellLocation = ActiveCell
 
' --- your code here 
 
' -- end of code
InitCellLocation.Select

Cheers
Shasur

JP · November 28th, 2011, 04:08 PM

Since the Range.Address Property returns a String type, you should declare CellLocation as a String:

Code:

Dim CellLocation As String

Then after assigning the ActiveCell.Address to CellLocation and running the rest of your code, use

Code:

 
Range(CellLocation).Select

at the end.