Excel 2003. I programmatically build a year to date master workbook from the
monthly workbooks we create. The master and the monthlys all have the same
number of sheets. I simply copy sheet 1 of January, sheet 1 of February, and
so on into sheet 1 of the master, with each sheets data being tacked on to
the bottom of the previous month's data. Each sheet in the monthly books has
had it columns autoifitted to the data. However, when I copy into to master
book the column widths are those of the January data. Thus, if any
subsequent months have data requiring a wider column, then the data is
displayed as #######.

How may I check to see if there is ANY data in a particular column that does
not have enough space to be displayed? I can take it from there. I just
need to know how to detect if a column has data that is too wide to display.
Thanks for any help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org