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?
|