Hi,
I found a piece of VBA code on this board, which I could very much use. I would just like to tweak it so that it won't show column widths for EVERY column, but just for a selection. Would appreciatie any help!
Cheers.
I found a piece of VBA code on this board, which I could very much use. I would just like to tweak it so that it won't show column widths for EVERY column, but just for a selection. Would appreciatie any help!
Cheers.
Code:
Public Sub ColWidth()
Dim i As LongFor i = 1 To 256
Cells(1, i).Value = Columns(i).ColumnWidth
Next i
End Sub