EntireColumn and merged cells
I am trying to select the entire column of the active cell (say it is C4).
In row 1 and row 2 there are several merged cells (say B1:G1 and B2:G2).
Range("C4").Activate
ActiveCell.EntireColumn.Select
' Where C4 is a cell found with a Find command
When I do this, all the columns containing the merged cells get selected,
not just the one I want to select. How can I bypass this problem?
|