Thread: UsedRange problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
  
Posts: 6
Default UsedRange problem
Many thanks Jim and Peter. I will test them both out.


Range("A1", Cells.SpecialCells(xlCellTypeLastCell))

Adjust A1 if you want to start from another cell.

--
Jim Rech
Excel MVP




Reply With QuoteReply With Quote