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.
Thanks,,
Bob
P.S. I am using Office Pro Plus 2010.
Bookmarks