how to select a single column when this column cross a merged cell

[cnEagle]

In Excel, some cells have been merged (e.g. cells(B3:E3)), I clicked the
column C and column C was been selected,and the vba was "
column(C:C).Select".
But when I ran this VBA,column(B,C,D,E)'re all selected.
How can I do?I just want to select Column C and Copy it.

[c***@gmx.de]

Any help on this one? Same problem for me- unable to select a single
column via VBA.

Post by cnEagle
In Excel, some cells have been merged (e.g. cells(B3:E3)), I clicked the
column C and column C was been selected,and the vba was "
column(C:C).Select".
But when I ran this VBA,column(B,C,D,E)'re all selected.
How can I do?I just want to select Column C and Copy it.