Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stretch image cover specific cell?
Does anyone have any suggestions on how to edit the following code to stretch
image fit for specific cell's size? I would like to locate the image cover the cell from B10 (left top corner) to C 13 ( right bottom corner), Does anyone have any suggestions on how to resize the and fit within specific cells? Thanks in advance for any suggestions Eric Private Sub Worksheet_Change(ByVal Target As Range) Dim myPic As Object If Target.Address = "$A$1" Then On Error Resume Next Set myPic = ActiveSheet.Pictures(1) On Error GoTo 0 If Not myPic Is Nothing Then myPic.Delete If Range("A1") = 1 Then ActiveSheet.Pictures.Insert ("C:\TempPic.JPG") Else ActiveSheet.Pictures.Insert ("C:\TempPic2.JPG") End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Image Stretch While Printing | Excel Programming | |||
Image Stretch On Printouts and Print Prieview | Excel Discussion (Misc queries) | |||
display image when specific value in a cell exist | Excel Discussion (Misc queries) | |||
Insering an image on a specific cell | Excel Programming | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) |