ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   xl2007 Pictures.Insert Does NOT Work anymore (https://www.excelbanter.com/excel-programming/378188-xl2007-pictures-insert-does-not-work-anymore.html)

Sean McPoland

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



All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com