need help in improving this macro
 

Thanks Steve

However, the excel macro I posted is in excel 4.0 and it is obviously
written in an excel sheet and saved as a macro. Converting that into
the current version and writting it into the VB editor is another
hurdle before I can add the suggestions you mentioned.

Any advise from anyone?