View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rodrigo Rodrigo is offline
external usenet poster
 
Posts: 20
Default Data Area in Excel 2005

Hi:

I need reconfigure the Data Area of a Worksheet in Excel 2003, i mean, i
have a worksheet with data only in range A1:C4, however when i try to get the
last cell of the worksheet, using
ActiveCell.SpecialCells(xlLastCell).Select, i get the cell F10... I tried of
eliminate and clear rows 5-10 and columns D-F, but didn`t work and still get
F10 cell like the last one.

Thanks

Rodrigo