How to increase (autofit) cell width automatically in all sheets at a time

Hi,


I have 50 excel files in a folder, each file contains approx 15 sheets. In each sheet, few cells (random cells) showing "######", instead of full cell content. I don't go each sheet to increase particular cell widths. Coz, it would become tedious. Is there any way(shortcut) to increase certain cells width(which are containing #####) in a workbook automatically. (or) Any macro for all workbooks in a folder.


thank you in advance.


regards
ajaypal