View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Positioning copied pictures

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