Selecting all Cells with Data?

[dave]

I'm writing a VB app to read an excel file that contains a data table. My
goal is to obtain all the column headings and corresponding cell values for
each column in the table.

Is there a simple method available to select a range of cells containing the
data? Other than looping through, and testing each cell...

One sheet may contain data from A1 through K25, and another perhaps from A1
to M15. It'd be nice to use an object method to return the Range A1:K25 in
the first case, and A1:M15 in the other.

Any ideas?

Dave

 

[Mike Fogleman]

Sheet1.UsedRange

Mike

 

[dave]

Thanks much.

Sheet1.UsedRange

Mike