Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures.Insert not working correctly in excel 2008.
This code doesnt work correctly in Excel 2008 but works in Excel 2003.
Range("F32").Select ActiveSheet.Pictures.Insert("T:\Sym-enh\CO\logo.bmp").Select Picture gets on top of the sheet instead of cell F32. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures.Insert not working correctly in excel 2008.
This is a bug
You can use this in 2007 as a workaround Sub Test() Dim myPict As Picture With Range("F32") Set myPict = .Parent.Pictures.Insert("T:\Sym-enh\CO\logo.bmp") myPict.Top = .Top myPict.Left = .Left End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Shashi" wrote in message ... This code doesnt work correctly in Excel 2008 but works in Excel 2003. Range("F32").Select ActiveSheet.Pictures.Insert("T:\Sym-enh\CO\logo.bmp").Select Picture gets on top of the sheet instead of cell F32. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste not working correctly in MS Excel '07 | Excel Discussion (Misc queries) | |||
Toolbar not working correctly in IE after loading Excel doc in bro | Excel Discussion (Misc queries) | |||
excel vlookup not working correctly | Excel Worksheet Functions | |||
Excel 2003 Subtotals not working correctly | Excel Worksheet Functions | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions |