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
|