Column Widths

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Black - 31 Aug 2007 12:51 GMT

Hi everyone,

Is there a way I can set columns ...

A
D
H
M
S
Z
AE

... to column width 3 in one line please.

Thanks in Advance.
All the Best.
Paul

Reply to this Message

Joel - 31 Aug 2007 13:24 GMT

Use a union
Sub test()

Union(Columns("A"), Columns("D"), Columns("H"), _
Columns("M"), Columns("S"), Columns("Z"), Columns("AE")). _
ColumnWidth = 3

End Sub

> Hi everyone,
>
[quoted text clipped - 13 lines]
> All the Best.
> Paul

Reply to this Message

Mike H - 31 Aug 2007 13:24 GMT

Paul,

Try this:-

Sub stance()
Range("A:A,D:D,H:H,M:M,S:S,Z:Z,AE:AE").ColumnWidth = 3
End Sub

Mike

> Hi everyone,
>
[quoted text clipped - 13 lines]
> All the Best.
> Paul

Reply to this Message

Paul Black - 31 Aug 2007 22:02 GMT

Thanks to both of you, thats exactly what I was after.

All the Best.
Paul

> Paul,
>
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Reply to this Message