Colum size

[bullit_nl]

Hello,

Is there a way to view multiple colum sizes in one time?


Thanks

 

[hedrijw]

View multiple column sizes in one time???

Please clarify!
This message was edited by hedrijw on 2002-08-23 02:30

 

[bullit_nl]

When i right click on for ex. column A i can view the column size.

I would like to view and maybe edit the column sizes for more the one column at one time.

Thanks

 

[Tall]

Hi!

Select the colums you wanna change the size to, then rightclick and select columsize

 

[Legacy 7259]

On 2002-08-23 03:09, Tall wrote:
Great sailors were not raised on calm seas.

Captain James Cook was.

 

[Jim North]

In the past I have needed to see the column widths. Here is a macro that will insert a row at the top and then insert the current column width in the used columns:

<pre>
Sub ColWidth()

Dim CurrCol As Long
Dim rng As Range
Dim TotalCol As Long

CurrCol = 0

' determine the number of columns in use
Range("A1").Activate
Set rng = ActiveSheet.Range("a1", ActiveSheet.Range("a1").End(xlToRight))
TotalCol = rng.Columns.Count

' insert a new top row
ActiveCell.EntireRow.Insert shift:=xlDown

Do While CurrCol < TotalCol
CurrCol = CurrCol + 1 ' Increment Column
Cells(1, CurrCol).Value = Cells(1, CurrCol).ColumnWidth
Loop

End Sub

ENJOY!!

</pre>