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