Background Copy Distorted
 

I'm using some simple code to copy a map that has some lat/lon point
plotted on it. The following code selects the range on the workshee
with the map and points and then paste them on a new worksheet. Th
problem is on the map sheet the background image is placed in the uppe
left corner (A1), but when I paste in the other form the image start
about 8 columns over and 4 rows down so I get the tiled effect. I'v
tried just doing a screen shot but ran into more hassle then it seeme
worth. Any suggestions?

With Worksheets(map)
.Range(.Cells(1, 1), .Cells(MaxRow, MaxCol)). _
CopyPicture xlScreen, xlBitmap
End With

With Worksheets(Worksheets.count)
.Paste Destination:=.Range("A" & int_PasteRow)
End With

The green points on the attached screenshot show the boundries of th
map. You can see on the top shot how the boundries fall perfectl
around the map, but the pasted portion is shifted and tiled

Attachment filename: ss.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=55587
--
Message posted from http://www.ExcelForum.com