I want to paste the results from a pivot table into a column. I want t
do this each time the pivot table refreshes so that it is pasting int
the first empy row of the column range (i.e. its appending to th
previous results.

I can think of two ways to do this but don't really know how to do it'

1) name first cell in paste column and

Range("A").Select
Range(Selection, Selection.End(xlDown)).Select
And paste destination = 1 extra row to this

2) Use dynamic past range and paste to it plus 1 extra row.

Any thoughts on how to code this?

Thank

--
Message posted from http://www.ExcelForum.com