Adjusting To Current Row Range in Marco
 

I have a database that exports the results of a query into a Excel
Spreadsheet. I am trying to build a marco that convert this information into
a Pivot Table. The only problem is the row count changes everytime you run
the query and the information is exported into Excel.

My questions is there a way to write the marco, so that it automatically
adjust to the number of rows that are exported from the database?

All help is greatly appreciated.
--
tmdrake