Problem with Cells Selection through macro.

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

Guest

Hello There,

I want to select a coloumn say A, through macro in a worksheet where from A
to O some 300 rows are merged.

Now when i use Column("A:A").Select it selects all the column from A to O
how can i select only "A:A"

Regards
 
If they are merged then you cannot. Effectively you only have one cell!
You could un-merge them select and re-merge, but I am not sure what that
delivers? Since any values placed in A will then appear in the new cell A:O
when re-merged.
 
As much as I don't like to use merge cells, you may find that if you upgrade,
the newer versions of excel handle merged cells better.

If I remember correctly, the behavior you described occurred in xl97.

Not much of a workaround, huh?
 

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

Set Column choice to a variable from a Drop Down 4
Problem with selecting a column in a macro 5
VBA set thick borders around non empty cells in range 0
Columns other than one selected by macro being erroneously selecte 2
Looping through columns 2
code breaks in macro 1
Data Cleanse Macro Running Very Slow 0
AMENDMENT IN MACRO 2

Back
Top