How to stop some shapes from copying to different worksheet

mcomp72

Board Regular
Joined
Aug 14, 2016
Messages
181
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2011
Platform
  1. Windows
  2. MacOS
I have some code that copies a range of cells from one sheet to another.

VBA Code:
sourceWS.Range(FirstCol & FirstRow & ":" & LastCol & LastRow).Copy targetWS.Range(FirstCol & FirstRow & ":" & LastCol & LastRow)

I used the Copy method, as I need it to copy cell formatting, formulas, etc.

It works fine, except for one thing -- there are some images that exist on the sheet that are also being copied by this line of code, and I don't want them to be, at least not all of them. Is there a way to stop the images from being copied using the above line of code? If not, is there another way to do the copy which will copy all the cell formatting, formulas, etc, but not the images? I could right separate code to copy the images I want to be copied.

FYI - My workbook needs to work on both Windows and Mac.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Marc L

Well-known Member
Joined
Apr 5, 2021
Messages
927
Office Version
  1. 2010
Platform
  1. Windows
A VBA help must see : the CopyObjectsWithCells property …​
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,132,912
Messages
5,655,910
Members
418,250
Latest member
Jebacmakro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top