Hi
I am using Excel 97 VBA. I want to put a company logo (picture) on th
top right position of each printed page of an excel sheet.

The page can be portrait or landscape and i have page setup set to
wide ie there may be auto shrink.

I am copying to cell A1 then doing 'ShapeRange.IncrementLeft' for
distance of total column width minus picture width.
This does not place the picture where i expect - it repeats exactly o
any one sheet but varies its placement on different sheets.

Any advice would be welcome.
TIA.
bil

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com