Number of Rows and Columns in MS Excel Export

[tranchemontaigne]

I've written VBA code to export MS Access data to MS Excel. I'm now working on making MS Excel Charts based upon this data, but am having a heck of a time defining the data range for the chart because the number of rows of data will constantly change.

Is there a good way to have MS Excel determine the number of rows that have data?

I'd rather not create a recordset object and do a loop count within MS Access prior to exporting the data if I can do something within MS Excel directly.
________
Silver Surfer Reviews

 

[namliam]

Selection.CurrentRegion.Select

Will select the current selected table with very very very very few exceptions.