Declaring a Range
 

Within a macro I want use the offset command and then return to a cell.

I have declared the variable CurrCell as Range

then

Set CurrCell = Range(Activecell)

and then I want to be able to return to CurrCell after offsetting around the
worksheet.

Any ideas?

Declaring a Range
 

Dim CurrCell as Range
Set CurrCell = ActiveCell

' offset around the worksheet

CurrCell.Select

--
Regards,
Tom Ogilvy


"Mikeymay" wrote in message
...
Within a macro I want use the offset command and then return to a cell.

I have declared the variable CurrCell as Range

then

Set CurrCell = Range(Activecell)

and then I want to be able to return to CurrCell after offsetting around
the
worksheet.

Any ideas?