PDA

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.
Thanks.

Paul_Hossler
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.

pike
04-24-2019, 05:42 PM
H Kerry,
just
Range("A1").Select

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

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

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

Rob342
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

Rob

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