View Full Version : [SOLVED] De-selecting cells after Paste

Kerry H
04-24-2019, 11:58 AM
I am copying several ranges from one sheet to 5 other sheets.
Is there an easy way to de-select the copied sells in the 5 WSs?
(all the copied cells remain shaded after sub completed)
I realize I can select a single cell in each of the WSs but that seems cumbersome.

04-24-2019, 12:49 PM
Application.CutCopyMode=false will 'unselect' the original copied cells

Kerry H
04-24-2019, 04:33 PM
Thank you, Paul.

Kerry H
04-24-2019, 05:01 PM
I am familiar with Application.CutCopyMode=false and already use it.
I'm trying to unshade the pasted cells, which seems to remain after the sub ends.

04-24-2019, 05:42 PM
H Kerry,

Kerry H
04-24-2019, 07:01 PM

I was trying to avoid doing that on 5 different sheets, given that some coders fret about using "select".
Is there any need to get rid of the shading?
I'm assuming that some users will not know enough about excel to do it manually and, thus, be worried about it.

Thanks, Kerry

04-24-2019, 08:08 PM
you can avoid it with
paste range = copy range
Range(“B1:B10”).value= Range(“A1:A10”).value

04-25-2019, 03:15 AM
As Paul said
Application.CutCopyMode = False
make sure it refers to the sheet you are coping from otherwise it doesn't work


Kerry H
04-26-2019, 07:58 AM
Thank you Rob