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

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.

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

Solution is to not select anything, just copy and paste it.

Columns("C:C").Copy
Range("H1").PasteSpecial

sub your desired range for the H1 reference.

On Nov 12, 10:25 pm, cnEagle
wrote:
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.