Help! I created a simple macro to launch a pivot table covering dat
with fields as follows:

Date Units Amount

I created a pivot table manually and the results was correct. Created
macro with the same instructions, tested it and it worked. However late
with a longer list of data the macro did not provide a correct answer a
compared to a manually created pivot table.

Any clue as to the problem? Does a pivot table created through a macr
'retain' the data range and therefore gives an incorrect result if th
data range is longer than the original

--
Tyrone Lope
-----------------------------------------------------------------------
Tyrone Lopez's Profile: http://www.excelforum.com/member.php...fo&userid=2219
View this thread: http://www.excelforum.com/showthread.php?threadid=47775