Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically fit an image into merged cells
can anyone tell me how to insert an image into excel so it appears in the
same place every time also so it resizes to the merged cells i have created |
#2
|
|||
|
|||
one way:
Insert the image then run this macro. Adjust the cell reference as desired: Public Sub PositionAndScalePic() Dim rArea As Range Dim dFactor As Double Set rArea = ActiveSheet.Range("J5").MergeArea With ActiveSheet.Pictures With .Item(.Count) .Top = rArea.Top .Left = rArea.Left dFactor = rArea.Width / .Width .Width = rArea.Width .Height = .Height * dFactor If .Height rArea.Height Then dFactor = rArea.Height / .Height .Height = rArea.Height .Width = .Width * dFactor End If .Placement = xlMoveAndSize End With End With End Sub In article , "dave" wrote: can anyone tell me how to insert an image into excel so it appears in the same place every time also so it resizes to the merged cells i have created |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
paste info into merged cells | Setting up and Configuration of Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |