Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Copy a fixed selection to the current cell...

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe I am overthinking this - but I need a macro that will allow me to copy the contents of cells A1:F5 to begin at the cell that is active when the macro is executed. I have tried creating a named range, and generating a macro, but always lose the focus of the starting cell...can anyone help resolve that problem?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-28 16:15, Todd K wrote:
    Maybe I am overthinking this - but I need a macro that will allow me to copy the contents of cells A1:F5 to begin at the cell that is active when the macro is executed. I have tried creating a named range, and generating a macro, but always lose the focus of the starting cell...can anyone help resolve that problem?
    Sub copyPaste()
    Range("A1:F5").Copy
    ActiveCell.PasteSpecial

    End Sub


    Regards,

    Gary Hewitt-Long

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just a little simpler...

    Range("A1:F5").Copy ActiveCell
    Regards,

    Juan Pablo González
    http://www.juanpg.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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