Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing Image In A Cell
Any way to insert a picture in a cell, fitted so as to set the row
height/column width accordingly and making the same of the exact size? -- Thanx in advance, Best Regards, Faraz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing Image In A Cell
Hi Faraz
Pictures reside in the different layer above the cells. You can move and resize them to be on top of the cell; and format the picture to move and resize with cells . Dim myPic As Object Set myPic = ActiveSheet.Pictures.Insert("C:\untitled.bmp") With myPic .Top = Range("B9").Top .Left = Range("B9").Left .Height = Range("B9").Height .Width = Range("B9").Width End With -- Jacob "Faraz A. Qureshi" wrote: Any way to insert a picture in a cell, fitted so as to set the row height/column width accordingly and making the same of the exact size? -- Thanx in advance, Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixing cell value | Excel Discussion (Misc queries) | |||
Fixing cell color changes when copying in Excel 2007 | Excel Discussion (Misc queries) | |||
Fixing Last Cell | Excel Discussion (Misc queries) | |||
Fixing multiline cell | Excel Worksheet Functions | |||
Fixing a single cell reference keeping others dynamic | Excel Worksheet Functions |