View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina faustino Dina is offline
external usenet poster
 
Posts: 10
Default How to obtain the shortest range that encloses all the non empty cells?

Hi,

How to obtain the range in which cells are defined? I mean, the Sheet has a
huge number of rows and columns but you use a few of them. Suppose you fill
the cells D20 and H40, and all others are untouched. I need to obtain the
range (D20:H40) How can I do that without scanning all the universe of
cells...?

Thanks in advance
Faustino