Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste not working correctly in MS Excel '07 DJMarkAnderson Excel Discussion (Misc queries) 3 August 31st 09 11:02 PM
Toolbar not working correctly in IE after loading Excel doc in bro Larry_Ulster Excel Discussion (Misc queries) 4 July 15th 09 09:24 PM
excel vlookup not working correctly Steve Excel Worksheet Functions 3 October 29th 06 04:47 PM
Excel 2003 Subtotals not working correctly Mike Sattan Excel Worksheet Functions 4 February 26th 06 07:28 AM
Sum function not working correctly in Excel (Skips Cell) Tony Excel Worksheet Functions 5 November 29th 04 11:52 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"