mcomp72
Active Member
- Joined
- Aug 14, 2016
- Messages
- 275
- Office Version
- 365
- 2019
- 2016
- 2011
- Platform
- Windows
- 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?
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?