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