ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing move my camera picture (https://www.excelbanter.com/excel-programming/400828-printing-move-my-camera-picture.html)

Christina

Printing move my camera picture
 
hi all

I have a printing problem. I have a macro that capture a block of range
(using camera command) and place it at a position then resize that block with
a dimension in order to fit in reserved place. The codes are as follow:
ActiveSheet.Range("GR1_CAMERA").Select
Selection.Copy
ActiveSheet.Pictures.Add(201.75, 192.75, 375, 328.5).Select
Selection.Height = 294
Selection.Width = 410.25

These codes work fine in most of my computer. However, on a computer , when
I print it, I see the block camera image is not fit in my reserved place. It
looks bigger and it is moved a little bit to the right. I think that is from
the printing setting. Any ideas will be very appreciated.

Christina.



All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com