VB and Pivot Tables

[velohead]

Hi All,

I'm using Excel 2003

I have a spreadsheet where I frequently....
delete a particular pivot table
then recreate the same pivot table.

Can I automate the pivot table creation using VB ?
The data is contiguous, and the pivot table is very simple..
columns = months
rows = descriptions
values = amounts

Thanks

 

[GlennUK]

Good to hear. My pleasure to help