Printing move my camera picture

C

Christina

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top