Declaring a Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Dim CurrCell as Range
Set CurrCell = ActiveCell

' offset around the worksheet

CurrCell.Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy to Visible Cells only;Modify Code 11
Direction of looping through objects 5
Merged Cells Autofit Macro Code 1
Does Range("A1,B2,C3,etc") have a max number of cells? 2
Opposite of Intersect function - an example 1
Help with Loop / Array / Ranges 1
Row height 3
Worksheet_Activate not working on multiple cells 1

Back
Top