+ Reply to Thread
Results 1 to 5 of 5

copy paste with formatting bypassing clipboard

Hybrid View

rossg copy paste with formatting... 01-31-2013, 03:00 AM
:) Sixthsense :) Re: copy paste with ... 01-31-2013, 03:11 AM
rossg Re: copy paste with ... 01-31-2013, 03:17 AM
:) Sixthsense :) Re: copy paste with ... 01-31-2013, 03:39 AM
Norie What is Selection when you... 01-31-2013, 04:16 AM
  1. #1
    Registered User
    Join Date
    01-01-2013
    Location
    melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    55

    copy paste with formatting bypassing clipboard

    hi
    i started to use this method of copy paste
    Selection.Copy Destination:=Workbooks(SupplierKPIFile).Sheets("By State By Dept").Range("A4")
    rather than

    Selection.Copy
    Workbooks(KPIFile).Activate
    Range("A701").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    the "copy Destination:=" doesnt keep the formatting. is there a way this can be done?

    i want to bypass clipboard for speed, as there is alot of copying and pasting between the source data and templates

    thanks

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: copy paste with formatting bypassing clipboard

    Your first code should do that job......

    SupplierKPIFile refers to??


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-01-2013
    Location
    melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: copy paste with formatting bypassing clipboard

    the first code doesnt copy formatting across. ie if its $130, then it only copies across as 130
    if its 17.3% it only copies across as .173

    i want to use this code method, but keep formatting

    Selection.Copy Destination:=Workbooks(another_file).Sheets("Sheet1").Range("A4")

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: copy paste with formatting bypassing clipboard

    It will work fine if both of your copy and paste ranges are unique

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    What is Selection when you run this code?
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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