VBA Column ().Select

[Arie Bos]

I have data in columns A - K
to clean column A, I use:
Columns("A:A").Select
Selection.ClearContents

this works fine, next step is to do something in column B, so I use
Columns("B:B").Select
.....

But now all columns with data are selected, not just column B. Same happened for Columns("H:J").Select or any other selection


Why is this happening?

 

[Fluff]

At a guess, you have merged cells.

 

[Arie Bos]

AAAAAARRRGGhhhhhh....... Thanks Fluff...

 

[Fluff]

You're welcome

 

[bellman101]

At a guess, you have merged cells.

I think that's more than a guess!

(Not sure which version this first appeared in, or which you have, but) if you don't want to lose the formatting of any merged cells, unmerge them, right click the same selection of cells that were merged, and on the alignment tab, in the Horizontal there is 'Center across selection'.

It won't behave in any way like a merged cell, but it will still look like one for presentation.