View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SpeeD SpeeD is offline
external usenet poster
 
Posts: 65
Default Align picture to the right side of a cell...

Hi to all...

I need to align a picture to the right side of a cell, but i cant make this
work.. i can do it to the left...

Dim myPict As Picture
With ActiveSheet.Range("B5")
Set myPict = .Parent.Pictures.Insert("C:\jorge\jorge.jpg")
myPict.Top = .Top
myPict.Left = .Left
myPict.Placement = xlMoveAndSize

This is an insert code, but you get the picture...

Can anyone help me?

Thanks in advance
SpeeD