Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating a Picture
Hi....
I am having trouble with pasting a picture. I have this door that is drawn in a worksheet and I want to copy that door and paste it into another sheet in a confined space. My problem is how do you copy that picture over and paste it into that space and having it resized so it fits into the space and it looks proportional to the original drawing. ActiveSheet.PasteSpecial Format:="MS Office Drawing Object", Link:=False, _ DisplayAsIcon:=False Selection.ShapeRange.LockAspectRatio = msoTrue Selection.ShapeRange.Height = 277.5 Selection.ShapeRange.Width = 179.25 Selection.ShapeRange.IncrementLeft 8.25 Selection.ShapeRange.IncrementTop 8.25 This is what I had..tried it using Picuture object too but with different sizes of the door it doesn't work right..what am I doing wrong..or how should I do this?? Wendy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
Picture formating units | Excel Discussion (Misc queries) | |||
Conditiol formating - return picture | Excel Discussion (Misc queries) | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
Formating a picture to fit cell automaticaly | Excel Discussion (Misc queries) |