Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy,Paste Info. into a range (2000)

    What code can allow me to copy and paste a named range into the cell of my choice.
    I want to asked where to place the copied data. The data consists of Text in multiple cells and formulas in others.
    Range A136:H136. I want to add it to a ctrl + key to allow insertion of the copied data from that named ranged.
    thanks,
    mark driver

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy,Paste Info. into a range (2000)

    The following code will copy the range A136:H136 on worksheet Sheet1 to the current selected cell.

    <pre>Public Sub MyCopy()
    Worksheets("Sheet1").Range("A136:H136").Copy Destination:=Selection
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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