Selecting all Cells with Data?

  • Thread starter Thread starter dave
  • Start date Start date
D

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
 
Back
Top