Hi all,

Apologies if this question has been answered before, but my forehead is bloody after banging it against the wall in an effort to get this code to work...

I have a worksheet ("Environment") with a named range ("EnvCode"). This range will change in size quite frequently, with rows added or possibly delete regularly. I also have an existing PPT file ("PPTCode").

I need to be able to assign a macro to a button on the "Environment" worksheet that will select the "EnvCode" table, copy it, and then paste it onto a particular slide (let's say Slide 5) in my "PPTCode" file. But I need to paste it as a table, not as a picture.

For the life of me, I cannot find examples of code that will do anything other than paste a picture. I could just manually Paste Special and paste a link, but if the source table changes dimensions, it isn't reflected in the linked table in PPT.

Has anyone done this before? Any help would be greatly appreciated.



P.S. I am using Office Pro Plus 2010.