Is the zoom setting on the sheet wth the problem at exactly 100% when you do
the copy and align? I have found it to cause problems like the one you
described.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"keepitcool" wrote in message
...
something curious (Excel version 8.0 thru 11.0..)


This works:
I insert a png or gif into a worksheet.
I right align it with cell H2's right border.
I do print preview. The picture is correctly right aligned with the
underlying cell.

This DOESN't work:
I copy the png from sheet 1
I paste it into another sheet or workbook
I repeat the alignment process... In normal view everything looks perfect.

I do print preview... and the damned picture has moved 10 or 20 pixels to
the left, and there's NO way that I know of to get it properly aligned.

I've tried many variations.
PasteSpecial metafile/pastespecial bitmap etc. etc.
Changing Printers...

I don't want to store this picture on disk, I need to copy it from my
addin...

Anyone?


keepITcool




< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool