View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean McPoland Sean McPoland is offline
external usenet poster
 
Posts: 7
Default xl2007 Pictures.Insert Does NOT Work anymore

the following code no-longer works in xL2007 - MS a Bug?

Cells(gposV, gposH).Select
ActiveSheet.Pictures.Insert(filespec).Select

where V and H are the place I want to insert the picture.

This worked perfectly yesterday when on 2003 - but today after installing
2007 - nope.

The V and H are set,
the Insert inserts the picture

But at a random location and NOT at the expected V and H location...

Obviously this is a bit of a pain when inserting 20-30 pictures to a sheet
as they all have to be manipulated manually to place for now...

Thoughts please
regards
Sean