Hi,
I want to change column width on the following columns in my worksheet: O, S, W, AA, AE, AI from 2 to 1.
What I have is this:
The problem is that it is selecting all columns from B to AI. I have some merged cells whitin the range, so I guess that that has something to do about it, but I can't figure out what to do. Can anyone help me with this?
However, it does work when I do it manually (when recording the macro).
I want to change column width on the following columns in my worksheet: O, S, W, AA, AE, AI from 2 to 1.
What I have is this:
Code:
Range("O:O,S:S,W:W,AA:AA,AE:AE,AI:AI").Select
Selection.ColumnWidth = 1
The problem is that it is selecting all columns from B to AI. I have some merged cells whitin the range, so I guess that that has something to do about it, but I can't figure out what to do. Can anyone help me with this?

However, it does work when I do it manually (when recording the macro).