I have something different in mind!

After selecting the cells I create kind of cache-table or bette
cache-sheet
which i use as a xlDatabase for building the new pivot table. maybe yo
now
a better way. copy and paste is not the solution defenetly becaus
otherwise
I wouldn't be interested using excel VBA programming at all...

Maybe I can write the cache-table (selection from the pivot table) i
an array
instead of tmp-sheet? would be more elegant I guess!

I need your advise!

cheers,

filipu

--
filipu
-----------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=125
View this thread: http://www.msusenet.com/t-187043290