View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johan[_2_] Johan[_2_] is offline
external usenet poster
 
Posts: 11
Default Placing picture with code

Excel 2003
I have a sheet with only a graph.
With a macro I want to insert a picture on the sheet.
I want the picture to be on the upper half of the sheet and centered.
I use this macro;

ActiveChart.Pictures.Paste.Select
Selection.ShapeRange.IncrementLeft 219#
Selection.ShapeRange.IncrementTop 171.75

This works perfectly with my stationary computer. But when I run the
macro on a laptop the picture is not in the right position.
How do I solve this problem?