Results 1 to 3 of 3

Thread: [RESOLVED] Unselect the "Copied" range

  1. #1

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Resolved [RESOLVED] Unselect the "Copied" range

    how in code do I deselect the Copied range ( Flashing dotted line)

    thanks!
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  2. #2
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: Unselect the "Copied" range

    VB Code:
    1. Range("D20").Select
    2.     Application.CutCopyMode = False

    By the way, if your objective is to copy one range and paste it to another, you don't necessarily need to select any ranges:

    VB Code:
    1. Range("D6:F6").Copy Range("D8")
    Last edited by VBAhack; Sep 28th, 2005 at 02:41 PM.

  3. #3

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Unselect the "Copied" range

    thanks!

    (I have created an autocopy xla.. so I turn it on.. select range.. it autocopies.. then I click elsewhere and it pastes. thats when I wanted the "deselect" to happen)
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width