Is there a way in Excel to insert a picture into a group of merge.

[Rich Ulrich]

Is there a way to insert a picture into an Excel spreadsheet and have the
picture auto fit into a grop of merged cells? Or do I have to manually
resize the picture every time?

 

[Frank Stone]

hi,
not possible.
image controls are objects that "float" on top of the
sheet. they cann't be assigned to cells.
you can set the size. size the format control to the size
you want it. Right click the image control, click
properties. set the autosize to false.
Regards
Frank.

 

[Dave Peterson]

You could use a macro that fits the picture over the current selection:

Option Explicit
Sub testme01()

Dim myPictureName As Variant
Dim myPict As Picture

myPictureName = Application.GetOpenFilename _
(filefilter:="Picture Files,*.jpg;*.bmp;*.tif;*.gif")

If myPictureName = False Then
Exit Sub 'user hit cancel
End If

With Selection
Set myPict = .Parent.Pictures.Insert(myPictureName)
myPict.Top = .Top
myPict.Width = .Width
myPict.Height = .Height
myPict.Left = .Left
myPict.Placement = xlMoveAndSize
End With
End Sub