PDA

View Full Version : Solved: Show Width Of Selected Columns...



Wolfgang
06-20-2007, 05:03 AM
Hi All...

I have a workbook which holds data regarding the production process of a precision tool.

Data are in columns A through CS.

Is there a way to calculate the width of those columns in cells A2 to CS2 such that each cell shows the widths, like A2 = 3, B2 = 11, C3 = 12 and so forth...?

An example workbook is attached...

Thank you very much...

Best,
Wolfgang

Bob Phillips
06-20-2007, 05:43 AM
=CELL("width",A1)

and copied across

Wolfgang
06-20-2007, 05:50 AM
Hi Bob,

Thank you very much and Tristan will never make it...

Best,
Wolfgang