Range.Copy without copying drawing objects

Is there a way to exclude copying drawing objects when calling Range.Copy?

Thanks.

@vonH,

I think you may try to use Range.CopyData or Range.CopyValue method for the purpose. Alternatively, you may remove or hide all drawing shapes before implementing the copy operation.

1 Like