Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Cells Selection through macro.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Cells Selection through macro.
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. -- Cheers Nigel "Rahul Gupta" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Cells Selection through macro.
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? Rahul Gupta wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to include more cells for selection to print | Excel Discussion (Misc queries) | |||
Macro to select cells and then new selection from selected cells | Excel Programming | |||
Text selection macro problem | Excel Programming | |||
How do I print a selection of cells using a macro? | Excel Programming | |||
problem with selection when calling macro externally from VB6 | Excel Programming |