CODEWITHSUNDEEP
vbaexcel
Moe Nay
Moe Nay

Reputation: 99

Placing a picture in a worksheet, relative to a cell

How do I place the picture (vSelection) under "data" Sheet Cell U24?

This is placing the picture in the wrong location.

Top = Sheets("Data").Range("u24").Top
Left = Sheets("Data").Range("u24").Left

Set oShape = oActive.Shapes.AddPicture(vSelection, True, True, Left, Top, 80, 80)

Upvotes: 1

Views: 64

Answers (1)

Stewbob
Stewbob

Reputation: 16899

If you want it to appear 'under' cell U24 you need to get the 'top' of cell U25.

Top = Sheets("Data").Range("U25").Top

Upvotes: 2

Related Questions