ActiveX
To add formatted data
You can set formatted data using different properties or methods, depending on the data you have. For more detailed information about each of these properties and methods, see the property or method topic in the ActiveX Reference
Method or Property | Use to set . . . |
---|---|
Clip | Block of data, where tab characters separate columns and carriage return and linefeed characters separate rows. |
Text | Data for cell, column, row, or sheet as specified using Col and Row properties. Sets the same data in each cell if you set multiple cells. |
SetText | Data for cell, column, row, or sheet as specified using Col and Row parameters. Sets the same data in each cell if you set multiple cells. |
SetArray | Data for a block of cells or the entire sheet |