Results 1 to 3 of 3

Thread: worksheet.copy

  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: worksheet.copy

    I have a code to copy a worksheet and create and new file with it, then email it.

    This way copies the formulas, is there a way to just copy the data, kinda like a paste specials with values not formulas?

    TIA

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Try the macro recorder, and selecting the entire worksheet, then in the new worksheet/workbook, select cell A1 and Paste Special. See what code you get and modify for general use.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    Thanks, found a work around doing what you said.

Posting Permissions

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