agarwaldvk
02-19-2009, 07:44 PM
Hi Everybody
Please find attached herewith a spreadsheet showing some graphs and some codes as well for copying and pasting these graphs as pictures and some code for Custom Printing facility.
This is the same code that I have posted in one of my other posts.
The company data in the spreadsheethas been removed and it has been replaced with random number data).
You will notice that the worksheet "Comparative Graphs - Orig" has 32 graphs none of which have been copied and pasted as pictures. The same 32 graphs on the "Comparative Graphs" worksheet have all been copied and pasted as pictures using code in Module1. The Custom Printing code is also available in one of the module sheets. As a result of running the code in Module1, I notice that the height of the "copied and pasted as picture" graphs is marginally greater than that of the corresponding original graphs. This can be actually can be seen on the print preview either using the built-in Print Preview or my Custom Printing code by clicking on the control on the worksheet.
To see the difference more clearly just tick the checkbox on the Sheet tab of page setup menu at the start and you will see that whilst the top of each of these picture graphs is pretty much the same but the heights have margingally increased.
Hopefully, someone might be able to point to me as to where am I going wrong? Thanks in anticipation.
Best regards
Deepak Agarwal
Please find attached herewith a spreadsheet showing some graphs and some codes as well for copying and pasting these graphs as pictures and some code for Custom Printing facility.
This is the same code that I have posted in one of my other posts.
The company data in the spreadsheethas been removed and it has been replaced with random number data).
You will notice that the worksheet "Comparative Graphs - Orig" has 32 graphs none of which have been copied and pasted as pictures. The same 32 graphs on the "Comparative Graphs" worksheet have all been copied and pasted as pictures using code in Module1. The Custom Printing code is also available in one of the module sheets. As a result of running the code in Module1, I notice that the height of the "copied and pasted as picture" graphs is marginally greater than that of the corresponding original graphs. This can be actually can be seen on the print preview either using the built-in Print Preview or my Custom Printing code by clicking on the control on the worksheet.
To see the difference more clearly just tick the checkbox on the Sheet tab of page setup menu at the start and you will see that whilst the top of each of these picture graphs is pretty much the same but the heights have margingally increased.
Hopefully, someone might be able to point to me as to where am I going wrong? Thanks in anticipation.
Best regards
Deepak Agarwal