Purpose of the Macros
|
|
The macros introduced here help in editing Excel files: |
- |
in copying Excel files from one place to another, and - if a user wants -
appending a table after another; and - at the same time - if a user wants -
changing data in each cell to the format preferred by the user -
with also the option to make no changes to format;
|
- |
in removing spaces in front of and after contents of cells - by applying 'LTRIM' and 'TRIM' functions
in a selected columns;
|
- |
in copying equation or other cell contents in a column, from a cell and pasting it to all cells of the column
that belong to the table;
|
|
|
|