Handling placement of pictures with VBA in Excel. 1

[sec12205]

How do I code the pasting of pictures in a worksheet to ensure they don't overlap? Is there a way to find out the edge of a picture then paste after it (or something like that)?

Thanks!

 

[SkipVought]

Hi.

Each object has the following properties that you can use to position without overlapping...
Top
Left
Width
Height

So if you had Three objects that you wanted to align at the top 2 across & 2 down...

With obj1
   .Top = 0
   .Left = 0

   obj2.Top = .Top
   obj2.Left = .Left + .Width

   obj3.Top = .Top + .Height
   obj3.Left = .Left
End With

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[MeGustaXL]

Skip, that is SO cool!

No more counting and working out positions for me!

YDM

Crash