Revision history [back]
 | 1 | initial version |
The method to maintain format when storing a range as a variant is to use the Range.Value property instead of the Range.Text property. When using Range.Value, the variant will store both the values and formatting of the range.