Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010

    Unanswered: how to copy range of excel data

    Hi all;

    Just a question on excel. I want to programatically copy a range or table or data in excel from one sheet into another sheet.

    Is there any way for this.

    thank you.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Yes. You can use a range's name to set a range object to that range, and then use the copy and paste methods of the range object as normal.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  3. #3
    Join Date
    Sep 2014
    Try this -

    Sheets("Sheet2").Range("A1:A12").Value = Sheets("Sheet1").Range("A1:A12").Value

    to copy values from range A1:A12 from sheet1 to the same cells on sheet2.


Posting Permissions

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