Results 1 to 5 of 5

Copy and paste values and number formats pastes formatting

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    AR
    MS-Off Ver
    Excel 2007
    Posts
    2

    Copy and paste values and number formats pastes formatting

    Hello, I made a macro that prints a formula sheet from a more complex information sheet. Most everything works except the Selection.PasteSpecial script leaves the source formatting. The script is below. I tried altering the "Selection.PasteSpecial Paste:=xlNumberFormats, Operation:= _xlNone, SkipBlanks:=False, Transpose:=False" line by making two lines, one for values and the other for number formats. This lead to another error.

    Sheets("Version 1").Select
    Range("A7:J78").Select
    Selection.Copy
    Sheets("Kitchen Print").Select
    Range("A7").Select
    ActiveSheet.Paste
    Selection.PasteSpecial Paste:=xlNumberFormats, Operation:= _
    xlNone, SkipBlanks:=False, Transpose:=False
    Range("G6:G57").Select
    Application.CutCopyMode = False

    Any help would be greatly appreciated.
    Last edited by Canthandlemyhandle; 12-27-2012 at 06:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1