How can I automate the 'Camera' function in Excel VBA? I
tried using the record macro option but this doesn't work.
I just want to copy a snapshot of a pivot table from one
sheet into another using the 'camera' option.
Thanks