How to actually select ONE column

Piblon · June 23rd, 2004, 06:20 AM

Hi
I have two cells that are merged, eg. E1 and F1.
Now I want to choose one column like:
Columns("F:F").Select
Range("F2").Activate
With Selection
    .HorizontalAlignment = xlGeneral
    .VerticalAlignment = xlBottom
    .WrapText = False
    .Orientation = 0
    .AddIndent = False
    .ShrinkToFit = False
End With
No matter how I try, it ends up in selecting both columns.
Anyone got any idea how to fix it?

Thanks in advance
Piblon

AlfD · June 25th, 2004, 06:03 AM

You can't select a column if it contains merged cells.
Alf

Piblon · June 29th, 2004, 06:08 AM

Ok
Thanx

helentoomik · June 29th, 2004, 06:21 AM

However, you don't need to select the range for formatting it. Try this:

Code:

With Columns("F:F")
    .HorizontalAlignment = xlGeneral
    .VerticalAlignment = xlBottom
    .WrapText = False
    .Orientation = 0
    .AddIndent = False
    .ShrinkToFit = False
End With

Piblon · June 29th, 2004, 08:34 AM

I tried the last one and that really did the trick.
Thanks