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

    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
    Posts
    233
    dim v as variant

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

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    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.

Posting Permissions

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