[diggeryo]

I am using Microsoft Excel 2007. I receive many different documents during the week with a different number of columns in each. But the one thing they have in common is that they each have A LOT of columns. With each file, I need to find out all of its column widths. I've been doing this one column at a time--right clicking on the column header, clicking on "column width," and making a note of the number listed.

But it dawned on me that it might be possible to generate some type of report or something in Excel that will display the width of all columns with data in it. Is there a way to do just that?

thanks,
mike.

[Advertisements]

diggeryo,

the following VBA lines should get you started
you could use debug.print or msgbox to display the results


a = Columns("A:A").ColumnWidth
Debug.Print "Column A width = ", a

b = Columns("B:B").ColumnWidth
Debug.Print "Column B width = ", b


regards
DSM

[dsm]

diggeryo,

the following VBA lines should get you started
you could use debug.print or msgbox to display the results


a = Columns("A:A").ColumnWidth
Debug.Print "Column A width = ", a

b = Columns("B:B").ColumnWidth
Debug.Print "Column B width = ", b


regards
DSM