in reply to Pivot data in Excel via Win32Ole

With my queried data, my range will change each time
I see no problem with that, you can calculate the range. You have the number of rows and cols returned by the DB query.

If I didn't understand correctly, than you have to provide a working example of what you do and the expected results.