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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strip out certain rows that have merged cells 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel 2013 Merge Data 2
Import multiple workbooks to current workbook in specified row number 0
Recorded macro selection widened 4
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Clean this select case code up a bit. 2
Search for empty cells and move cells next to 10

Back
Top