ActiveX

To save to a buffer

Use the SaveToBuffer method or the SaveBlockToBuffer method, and set the parameters as needed:

1. If you have multiple sheets and are saving a block of cells, specify the Sheet first.
2. Set the Col, Row, Col2, and Row2 parameters to specify the block of cells for saving a range of cells to a buffer.