| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Range Offset property needed
Yesterday, I found something by accident.
I meant to access the cell above ActiveCell as ActiveCell.Offset(-1, 0). Instead, I referred to ActiveCell(-1, 0) which seemed to refer to ActiveCell.Offset(-2, -1). I thought and concluded ActiveCell is equivalent to ActiveCell(1, 1). I can now refer to the cell above the current cell as ActiveCell(0, 1). Is this general? -- Walter Briscoe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with OFFSET statement needed | Excel Worksheet Functions | |||
| Range - Offset (Major help needed) | Excel Programming | |||
| Range Select with ActiveCell and Offset property | Excel Programming | |||
| offset property to define range | Excel Programming | |||
| Re : MS Excel’s Offset Property | Excel Programming | |||
Threaded Mode
