Anita,

Post your code - the changes required depend on the specifics of your
current code.


HTH,
Bernie
MS Excel MVP


"Anita" wrote in message
...


I have created a macro that inserts a pivot table using some data on
sheet1.
I thought that the macro would select the entire list of data to produce
the
pivot each time it is run but I notice in the code that it selects an
absolute range and the range will be different each time I run the macro.
How can I change the code to tell Excel to select the populated cells in
the
list from A1 to the end? Using v2003 - thanks

PS - I also made a mistake recording the macro and meant for one of the
value fields in the pivot table to perform a sum rather than a count is
this
easy to amend using code?

Anita