View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] erazmus@actrix.co.nz is offline
external usenet poster
 
Posts: 3
Default Problem with Range.Cells.Offset and Range.Cells( row + offset, col

Hi Rowan,

Thanks for the info regarding the cell offset, I just assumed that
'range.Cells( row, column)' was an absolute reference to the worksheet,
never stopped to think that it was working relative to the range, seems
so obvious now considering what was happening :P

Regarding the Dim As part, will take that on board.

Thanks again :)

Deon.