I have written a vba program that creates a report in excel. Most of the pages of the report are created at runtime. I have an image on a hidden worksheet that I need to place into one of the worksheets that is created at runtime. The image is an excel chart that I copied and pasted as a picture. I did this so that I could resize it easily and all of the elements of the chart would maintain their relative sizes. I have tried:
but I get an error message:Please Login or Register to view this content.
Run-time error '1004': Copy method of Picture class failed
I tried inserting the picture like this:
but I get the dreaded:Please Login or Register to view this content.
Microsoft Office Excel Has Stopped Working......Windows is checking for a solution to the problem
and then of course it closes down and restarts without ever finding a solution.
Any help would be greatly appreciated.
Bookmarks