Specifies how to copy the range.

Version Information
Version Added: Excel

Name Value Description
xlFillWithAll -4104 Copy contents and formats.
xlFillWithContents 2 Copy contents only.
xlFillWithFormats -4122 Copy formats only.