View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?