View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JasonS[_2_] JasonS[_2_] is offline
external usenet poster
 
Posts: 1
Default Probably the most easy question here...

Good morning / evening!
What's my ploblem, I created a database in MS Access, with 3 crosstab
queries in it. I want the results of those queries to be put in one Excel
file, on one worksheet, in new rows. It's easy when I use
TransferSpreadSheet method for the first query, but I don't know how many
cells (rows and columns) will it use. My question is, how to find out using
VBA, which cell is the last one, because I have to append results of the
second and third query to it. I don't know how to describe range of cells
when I'm not sure where cells on my worksheet are ending...

Thank you for your help,
with best regards, Jason