PASTE.SPECIAL Syntax 1

Macro Sheets Only

Equivalent to choosing the Paste Special command from the Edit menu. Pastes the specified components from the copy area into the current selection. The PASTE.SPECIAL function has four syntax forms. Use syntax 1 if you are pasting into a sheet or macro sheet.

Syntax

PASTE.SPECIAL(paste_num, operation_num, skip_blanks, transpose)
PASTE.SPECIAL?(paste_num, operation_num, skip_blanks, transpose)

Paste_num is a number from 1 to 6 specifying what to paste. Paste_num can also be quoted text of the object you want to paste.

Paste_num Pastes

1 All

2 Formulas

3 Values

4 Formats

5 Notes

6 All Except Borders

Operation_num is a number from 1 to 5 specifying which operation to perform when pasting.

Operation_num Action

1 None

2 Add

3 Subtract

4 Multiply

5 Divide

Skip_blanks is a logical value corresponding to the Skip Blanks check box in the Paste Special dialog box.

• If skip_blanks is TRUE, Microsoft Excel skips blanks in the copy area when pasting.
• If skip_blanks is FALSE, Microsoft Excel pastes normally.

Transpose is a logical value corresponding to the Transpose check box in the Paste Special dialog box.

• If transpose is TRUE, Microsoft Excel transposes rows and columns when pasting.
• If transpose is FALSE, Microsoft Excel pastes normally.

Related Functions

FORMULA Enters values into a cell or range or onto a chart

PASTE Pastes cut or copied data

PASTE.LINK Pastes copied data and establishes a link to its source

Syntax 2 Copying from a sheet and pasting into a chart.

Syntax 3 Copying and pasting between charts

Syntax 4 Pasting information from another application.

List of Command-Equivalent Functions