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.
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.