View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikeymay Mikeymay is offline
external usenet poster
 
Posts: 5
Default 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?