copy_range
Copies a source rectangle to a destination anchor in Excel, safely handling overlapping pastes. Choose to copy all, values, formulas, or formats; relative formula references shift automatically.
Instructions
Copy a source rectangle to a destination anchor (location objects, may name different sheets). what is 'all', 'values', 'formulas', or 'formats'. The destination is overwritten; the source is buffered first, so an overlapping paste is safe. Relative refs in copied formulas shift by the paste offset like an Excel copy unless adjust_formulas is false; absolute ($) anchors stay put. A hazardous workbook refuses unless allow_loss is true. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dest | Yes | ||
| path | Yes | ||
| what | No | all | |
| sheet | No | ||
| backup | No | ||
| source | Yes | ||
| allow_loss | No | ||
| verify_com | No | ||
| adjust_formulas | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||