Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please share how to place DRAFT Copy in Excel in background | Excel Discussion (Misc queries) | |||
How to make a cell copy the info from another (background colour i | New Users to Excel | |||
Plot area distorted when I copy Excel chart into Powerpoint | Charts and Charting in Excel | |||
How do I copy background (wallpaper) from one worksheet to another | Excel Discussion (Misc queries) | |||
Distorted Excel chart fonts when copy/paste to Word or Powerpoint | Charts and Charting in Excel |