Breaking News: Grepper is joining You.com. Read the official announcement!

copy paste special operation

Santosh Lama answered on September 29, 2022 Popularity 1/10 Helpfulness 1/10

answer copy paste special operation

copy paste special operation

Comment

Sub PasteSpecial()

    'Perform one Paste Special Operation:
    Range("A1").Copy
    'Paste Formats
    Range("B1").PasteSpecial Paste:=xlPasteFormats
    'Paste Column Widths
    Range("B1").PasteSpecial Paste:=xlPasteColumnWidths
    'Paste Formulas
    Range("B1").PasteSpecial Paste:=xlPasteFormulas

    'Perform Multiple Paste Special Operations at Once:
    Range("A1").Copy
    'Paste Formats and Transpose
    Range("B1").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True

    Application.CutCopyMode = False
End Sub

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: www.automateexcel.com

Tags: copy-paste operation whatever

Link to this answer
Share Copy Link