View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
no bosh no bosh is offline
external usenet poster
 
Posts: 6
Default discover cell causing column width more exactly

Actually I can figure out what the width of the cells are after auto
fitting makes them all enormous. I am hoping to discover the cell
which may be causing the width result, that autofit is adjusting to.

I have a worksheet importing things from several sources. Mostly
calendar data. I have had thew columns autofit for the final
formatting and display of the report.
All of a sudden I have one column come out extra wide and I suspect
some spaces or such in a cell.
Anyway I can investigate each cell's width property to see what is
causing this and then I can trim the output from the source.
Thank You all.
Scott