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.
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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.