| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Declaring a Range Object | Excel Programming | |||
| Declaring Variables | Excel Programming | |||
| declaring a msgbox | Excel Programming | |||
| Declaring a DLL | Excel Programming | |||
| DEclaring variables | Excel Programming | |||
Linear Mode
