Resize a shape

[ashmott]

Hello all

I have a shape which I am copying from one worksheet to another worksheet using the cells.copy command.

The problem is the shape always resizes (becomes too large). I have checked the properties of the shape and it should be H 2.65cm and width 9.26cm with scale H 100% and W 117%.

I have been trying with the command

Please Login or Register  to view this content.

etc but too no avail. I think this may be because the lockaspectratio is causing issues.

Alternatively a command to reset the shape to its original size like you can do from the properties area in excel would acheive the same thing.

Any help would be very much appreciated. Thanks all!

[Richard Buttrey]

Hi,

To reset the original size

Please Login or Register  to view this content.

Regards