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
|