ActiveCell Address

[Carl Clements]

Hi,

I need some VBA code that stores the ActiveCell Address (eg B24), which I need to return to later.

Is it something like the below?

ActiveCell.Address = SortCell
then
Range("SortCell").Select

Thanks,
Carl

 

[VoG]

That would be

SortCell = ActiveCell.Address

 

[villy]

Coult it be the reverse:
SortCell=ActieCell.Address

 

[Carl Clements]

What Data Type is the variable? I tried Dim and Public but neither worked

 

[villy]

yOu could use
Dim SortCell as Variant
This is for general purpose

 

[Carl Clements]

Thanks. It has correctly stored the cell location ($B$24) but when I use:

Range("SortCell").Select

I get 'Run-time error '1004:
Method 'Range' of object'_Global'failed

Should I use different code to return to cell B24?

 

[gaj104]

You just need to remove the quotes, as not to treat it as a piece of text

Range(SortCell).Select

 

[rafaelspeixoto]

You made 2 mistakes in your initial code. It should be:

SortCell = ActiveCell.Address
Range(SortCell).Select

you were putting Sortcell between "".


Edit: sorry for double post, gaj104 was faster