automatically extend columns while keeping a minimum width on specific columns

I'm currently using the attached code to extend columns. I would like use to it only for specific columns and keep and minimum column width. Any help would be appreciated.

HTML Code: 

Thanks
E.

How are the specific columns arrived at?
- predetermine (eg columns A,C, H auto fit, others minimum width)?
OR
- user asked to decide when values change?

If you favour the former
- which columns are to auto-fit?
- should all the other columns be left unchanged?

These 2 lines should be all you need in your change macro

Please Login or Register  to view this content.

The active column should stretch if latest data is wider than previous widest data in that column.
AutoFit tends not to work if the width of the column has already been changed from default to another specified width
- so how about fixing the headers with some spaces to ensure required width does not fall below 7 or create a dummy row (row1?) in order to achieve this
Merged cells cause problems for AutoFit - remove any merged cells