Workaround: Don't delete the first row of the range. Copy the contents of
the 2nd row to the first row and then delete the 2nd row (which is now the
first row).

--
George Nicholson

Remove 'Junk' from return address.


"unplugs " wrote in message
...
The problem is....

I define the range as :
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),10)

After I delete the data in the first row of this range, it becomes like
this:
=OFFSET(Sheet1!#REF!,0,0,COUNTA(Sheet1!$A:$A),10)

How to solve this problem... ? It really make me headche... :<

Nick Hodge or any other fren can guide me on this..?


---
Message posted from http://www.ExcelForum.com/