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