Macro: Pivot Table Ranges Vary

[tmarie]

Hi!
I am creating a macro and would like to add a pivot table. My table range will vary from file to file, how do I get the macro to select the range of cells that are populated on my sheet?
Thanks!
Tina

[JosephP]

if you know the data will start in A1 then I would use sheets("sheetname").Range("A1").Currentregion
if not you can use the UsedRange property of the sheet but this may occasionally include blank rows/columns.

[tmarie]

Thanks for the reply!
Pretty new to VB, so given what was suggested, how would I write that in VB if it reads:

Please Login or Register  to view this content.

Thanks!

[JosephP]

like this for instance

Please Login or Register  to view this content.