Determining if column(s) need to be Autofitted
 

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

Determining if column(s) need to be Autofitted
 

Turn on the macro recorder and Do
Select all cells
Edit=Find
###
uncheck Whole word and have it look at values (not formulas).

--
Regards,
Tom Ogilvy


"Chaplain Doug" wrote in message
...
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