Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: Copy a range, do lots of things then past that range

    I need to copy a range and hold it some how while i do other things. then retrieve it again and paste.

    Almost like creating a tmp worksheet in a workbook and pasting to there so i can get it again later after other operations are performed

  2. #2
    Join Date
    Oct 2003
    dim v as variant

    v= selection ' or Range(name)...

  3. #3
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    You can use the Worksheet or Range objects to hold references to worksheets or ranges in memory. However, I believe that changes to the actual sheet would be reflected in the objects as well.

    There's nothing to stop you from creating a new worksheet in the workbook, then pasting any data there for safekeeping and deleting the new sheet at the end of the operation.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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