Macro for selecting pages and formatting of tables
a. How can we design the macro to make a selection from one particular page to another particular page?
b. Once selected, do the following in the tables within those pages:
i. Delete – All rows including Date.
ii. Delete – All rows starting with “age”.
iii. Delete – All Zero Rows.
iv. Remove all rows with % symbols in them.
v. Add $ sign to all the numbers.
vi. Replace “>” with “five blank spaces”
vii. Spacing of cell – Before 5 pt, After 2 pt.
viii. Change the font size to 9.
|