How to copy cells without copying text box that is over top those cells

mcomp72

Active Member
Joined
Aug 14, 2016
Messages
275
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2011
Platform
  1. Windows
  2. MacOS
In my macro-enabled workbook, I have some VBA code that copies some cells from one sheet to another. Some of the ranges I am copying have a text box over them. However, I do not want to copy the text box to the other sheet, only the cells themselves. However, it always copies the text box, and I can't figure out how to not have it do that.

I did a test using a new workbook, and tried the copy & paste using keyboard shortcuts (Ctrl-C and then Ctrl-V) rather than VBA. Same thing happened. I recorded a video so you can see what I mean.

https://youtu.be/lyzDF4HuxVE

Anyone have any idea how to get it to NOT copy the text box?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Don't use Paste All but Paste Values ...

ScreenShot225.jpg
 
Upvote 0
For the cells themselves, I need it paste all the cell formatting, as well as the value within it. I also need it to paste a formula, if there is one in the cell. So unfortunately, Paste Values doesn't work for my needs.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

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