Microsoft KB Archive/31299

’LE Macro Command Copies Value, Not Format PSS ID Number: Q31299 Article last modified on 01-09-1989 PSS database name: D_MPlan

3.x

MS-DOS

Summary: You can use the ’LE command code in a macro to copy the value of a cell in the spreadsheet to another cell in the spreadsheet. The syntax of this macro command is as follows:

‘LE ’ ’

In this command, refers to the cell into which you want to copy the value. The section refers to either an actual value or a reference to a cell that contains the value you want to copy. Please note that when the value is copied from one cell to another, only the value is copied, not the format. The format of the value in the new cell will be the current format of the new cell. If you want to make sure the copied value will retain a certain format, you will have to explicitly write the formatting of the cell into the macro or previously format the cell where the value is to be copied.

Copyright Microsoft Corporation 1989.