Hello,
In Excel 97, I used record macro feature to create a
pivot table and it defined SourceData:= "20040608!
R1C1:R4C3") in the pivot table definition. Here 20040608
is the first sheet name and R1C1:R4C3 is the range for
the data. Each time when I run the macro these data would
be different, how can I figure out them and use as
SourceData in the pivot table.
Thanks,
Jim.