[pastespecial 옵션]
작성자 정보
-
모아 작성
- 작성일
컨텐츠 정보
- 7 조회
- 0 추천
- 0 비추천
- 목록
본문
[pastespecial 옵션]
예시문
.Range("C1:C5").Copy
.Range("D1:D5").PasteSpecial Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationAdd
xlPasteAll -4104
Everything will be pasted.
xlPasteAllExceptBorders 7
Everything except borders will be pasted.
xlPasteAllMergingConditionalFormats 14
Everything will be pasted and conditional formats will be merged.
xlPasteAllUsingSourceTheme 13
Everything will be pasted using the source theme.
xlPasteColumnWidths 8
Copied column width is pasted.
xlPasteComments -4144
Comments are pasted.
xlPasteFormats -4122
Copied source format is pasted.
xlPasteFormulas -4123
Formulas are pasted.
xlPasteFormulasAndNumberFormats 11
Formulas and Number formats are pasted.
xlPasteValidation 6
Validations are pasted.
xlPasteValues -4163
Values are pasted.
xlPasteValuesAndNumberFormats 12
Values and Number formats are pasted.
xlPasteSpecialOperationAdd 2
Copied data will be added with the value in the destination cell.
xlPasteSpecialOperationDivide 5
Copied data will be divided with the value in the destination cell.
xlPasteSpecialOperationMultiply 4
Copied data will be multiplied with the value in the destination cell.
xlPasteSpecialOperationNone -4142
No calculation will be done in the paste operation.
xlPasteSpecialOperationSubtract 3
Copied data will be subtracted with the value in the destination cell.
|
|
포인트 선물 선물명단 선물하기
최소 5P ~ 최대 100000000P 까지 가능합니다.
로그인 후 선물하실 수 있습니다.
선물 받은 내용이 없습니다.
관련자료
모아
ex.9
-
등록일 05:56
-
등록일 05:56
-
등록일 05:56
-
등록일 05:55