Cannot select single column to the left of freeze
 

In Excel 2003 in XP I have a sheet with column E:E frozen. (Works fine)

In a macro I then try to select A:A for modification - it turns out that no
matter what, or how (?) I try to mark columns to the left of the freeze- it
automatically extends to include the freeze column.
Thus Range("A:A").Select marks columns A:E, and B:C marks columns B:E and
so forth...

I included an unfreeze in the macro, which helped for a while. But now I
still get the frozen behaviour (and I have verified that the sheet is in fact
both unlocked and unfrozen).

Can someone pls explain what is happening. Is there a workaround?

Kind regards / Ake

Cannot select single column to the left of freeze
 

Freeze? What do you mean? Not a term I know.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ake" wrote in message
...

In Excel 2003 in XP I have a sheet with column E:E frozen. (Works fine)

In a macro I then try to select A:A for modification - it turns out that
no
matter what, or how (?) I try to mark columns to the left of the freeze-
it
automatically extends to include the freeze column.
Thus Range("A:A").Select marks columns A:E, and B:C marks columns B:E and
so forth...

I included an unfreeze in the macro, which helped for a while. But now I
still get the frozen behaviour (and I have verified that the sheet is in
fact
both unlocked and unfrozen).

Can someone pls explain what is happening. Is there a workaround?

Kind regards / Ake

Cannot select single column to the left of freeze
 

I couldn't reproduce the behavior. Did freeze panes with column F selected.
I then had no problem selection A:A whether the were frozen visible or not
visible.

Perhaps you have a row or more that has merged cells across A to E.

Excel 2003, Windows XP
--
Regards,
Tom Ogilvy

"Ake" wrote in message
...

In Excel 2003 in XP I have a sheet with column E:E frozen. (Works fine)

In a macro I then try to select A:A for modification - it turns out that
no
matter what, or how (?) I try to mark columns to the left of the freeze-
it
automatically extends to include the freeze column.
Thus Range("A:A").Select marks columns A:E, and B:C marks columns B:E and
so forth...

I included an unfreeze in the macro, which helped for a while. But now I
still get the frozen behaviour (and I have verified that the sheet is in
fact
both unlocked and unfrozen).

Can someone pls explain what is happening. Is there a workaround?

Kind regards / Ake

Cannot select single column to the left of freeze
 

"Tom Ogilvy" wrote:

"had no problem selection A:A" - Well,I can also do that- but not
programmatically.

"Perhaps you have a row or more that has merged cells across A to E" - Yes,
you are quite right, this was it. Thanks a lot.

So, I can indeed change the witdh of a single column if I do it by hand,
even if there is a merged cell across the column.

But I cannot change the width of that same single column if I try to do that
from within a macro. Then it always extends the selection to include all
columns of the merged cells. If not a bug, it is at least an inconsistency...

So, the last half of the question still remains- how can I do this
quick-and-dirty column width adjustment without having to know about all
possible merged cells and unmerge/merge them back again, in the macro. (or is
there perhaps a quick-and-dirty way to do that too ;-)

Humbly / Ake

Cannot select single column to the left of freeze
 

Ake,
Not exactly what your problem is, but this works for me:

With Range("A20:E20")
.MergeCells = True
End With
ActiveWindow.SplitColumn = 4
ActiveWindow.FreezePanes = True
Columns("A:A").ColumnWidth = 10

Note, there is no .Select in this code.

NickHK

"Ake" wrote in message
...
"Tom Ogilvy" wrote:

"had no problem selection A:A" - Well,I can also do that- but not
programmatically.

"Perhaps you have a row or more that has merged cells across A to E" -
Yes,
you are quite right, this was it. Thanks a lot.

So, I can indeed change the witdh of a single column if I do it by hand,
even if there is a merged cell across the column.

But I cannot change the width of that same single column if I try to do
that
from within a macro. Then it always extends the selection to include all
columns of the merged cells. If not a bug, it is at least an
inconsistency...

So, the last half of the question still remains- how can I do this
quick-and-dirty column width adjustment without having to know about all
possible merged cells and unmerge/merge them back again, in the macro. (or
is
there perhaps a quick-and-dirty way to do that too ;-)

Humbly / Ake

Cannot select single column to the left of freeze
 

Thanks Nick,

I think this was the workaround I was looking for. I did .select
(or.activate) just from old habits. And obviously that is where the
inconsistency (or bug) shows up.
It does always mark _all_ columns covered by the merge(s) in the column I
selected.

But of course I do not need to .select, just to modify the width of the
column ;-)

Thanks all, case closed / Åke