Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem inserting pictures in excel 2007 using macro.
Hi
I wrote a macro in excel 2003 which inserts a picture at a range cell identified in the macro. With excel 2007, it ignores the range identified and puts the picture in the top left of the work sheet. Has anyone else run across this problem and found a solution? dickiebird |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem inserting pictures in excel 2007 using macro.
You can use this in 2007 as a workaround
Sub Test() Dim myPict As Picture With ActiveCell Set myPict = .Parent.Pictures.Insert("C:\Users\Ron\Desktop\New Backup\ron.jpg") myPict.Top = .Top myPict.Left = .Left End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dickiebird" wrote in message ... Hi I wrote a macro in excel 2003 which inserts a picture at a range cell identified in the macro. With excel 2007, it ignores the range identified and puts the picture in the top left of the work sheet. Has anyone else run across this problem and found a solution? dickiebird |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting pictures into Excel Sheet at a particular size | Excel Discussion (Misc queries) | |||
inserting pictures in Excel 2007 different than in Excel 2003 | Excel Programming | |||
Inserting pictures in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel memory and speed when inserting pictures ??? | Excel Programming | |||
Powerpoint macro inserting pictures | Excel Programming |