Stop Excel VBA from Resizing Pictures When Copying Between Sheets
Question details
Keep pictures at their original dimensions when copying them between Excel worksheets with VBA.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pictures are copied from one worksheet to another where row heights, column widths, or picture placement settings may differ.
- Observed behavior
- Copied pictures may change size or lose quality.
Identify the source picture name in Excel's Selection Pane and the destination worksheet and cell. For the VBA method, save the workbook in a macro-enabled format such as .xlsm and enable macros if appropriate.
Set Picture Dimensions Explicitly in Excel VBA
Use this method to preserve the source picture's width and height after pasting it onto another worksheet.
In Excel, open Developer > Visual Basic, then choose Insert > Module.
Paste this procedure into the module, replacing the worksheet names, picture name, and destination cell with your own: Sub CopyPictureAtOriginalSize() Dim sourcePic As Shape Dim pastedPic As Shape Dim pastedRange As ShapeRange Dim destSheet As Worksheet Set sourcePic = ThisWorkbook.Worksheets("Sheet1").Shapes("Picture 1") Set destSheet = ThisWorkbook.Worksheets("Sheet2") sourcePic.Copy Set pastedRange = destSheet.Shapes.Paste Set pastedPic = pastedRange.Item(1) With pastedPic .LockAspectRatio = msoFalse .Width = sourcePic.Width .Height = sourcePic.Height .Left = destSheet.Range("B2").Left .Top = destSheet.Range("B2").Top .LockAspectRatio = sourcePic.LockAspectRatio .Placement = xlMove End With End Sub
Run CopyPictureAtOriginalSize from the VBA editor or Developer > Macros, then check the picture on the destination worksheet.

Adjust Picture Placement and Cell Dimensions Manually
Use picture properties when you want to control resizing without changing a macro.
Work with Spreadsheet Pictures in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and adjust pictures in WPS Spreadsheets; it does not fix VBA behavior in Microsoft Excel.

Frequently Asked Questions
Why does my picture resize when worksheet cells change?
The picture may be set to Move and size with cells. Right-click it, open Size and Properties > Properties, and choose Move but don't size with cells to preserve its dimensions.
How do I find a picture's name for a VBA macro?
In Excel, open Home > Find & Select > Selection Pane. Find the picture in the list and use its name in the Shapes collection.
Will setting Width and Height restore lost image quality?
No. Setting the shape's Width and Height controls its displayed dimensions, but it cannot restore image detail already lost through compression or a low-resolution source.
Should I use Move and size with cells to keep the original picture size?
Not necessarily. That option allows the picture to resize with its cells. Choose Move but don't size with cells if you want it to move with the cells while retaining its dimensions.




