ActiveX
To save to a buffer
Use the SaveToBuffer method or the SaveBlockToBuffer method, and set the parameters as needed:
- If you have multiple sheets and are saving a block of cells, specify the Sheet first.
- Set the Col, Row, Col2, and Row2 parameters to specify the block of cells for saving a range of cells to a buffer.