How to stop some shapes from copying to different worksheet

mcomp72

Active Member
Joined
Aug 14, 2016
Messages
275
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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
A VBA help must see : the CopyObjectsWithCells property …​
 
Upvote 0
Solution

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

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
Back
Top