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.
Application.CutCopyMode=false will 'unselect' the original copied cells
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thank you, Paul.
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,
justRange("A1").Select
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
As Paul said
Application.CutCopyMode = False
make sure it refers to the sheet you are coping from otherwise it doesn't work
Rob
Last edited by Rob342; 04-25-2019 at 03:39 AM.
Thank you Rob
Reply With Quote
