| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining if a value already exists in column(s) | Excel Discussion (Misc queries) | |||
| Determining if values in a column range are of same value. | Excel Programming | |||
| Determining Column to Use | Excel Programming | |||
| Determining Column to Use | Excel Programming | |||
| determining last column | Excel Programming | |||
Hybrid Mode
