"grahammal" wrote
in message ...
How can I set the column width to 0.75 from within the macro?

The macro recorder is your friend. You can easily find the answer to above
and similar questions yourself when you analyze the code produced by the
macro recorder

2) How do you set a variable that will be global, I need it to be
recognised in all macros within the same workbook?

If all your macros are in one module: DIM MyVariable at the beginning of the
module (in the 'General' section, i.e. outside of any SUB procedure)

If your macros are spread among different modules: PUBLIC MyVariable at the
beginning of any module.

Cheers,
Joerg