tranchemontaigne
Registered User.
- Local time
- Today, 03:39
- Joined
- Aug 12, 2008
- Messages
- 203
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
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
Last edited: