hi

i've tried recording a macro to generate a pivot table n it worked fin
except you should note that it will have problems if you have u
selected a field when u r recording the macro... because the next time
run the macro with a new set of data n this field is no longe
available, an error message would then pop up because excel cannot fin
that field to un select... hope this helps... in addition, the macr
might not work in different version especially if u r using 2003..
some macros recorded in 2003 will not work in older versions.... hop
this helps..

cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26224