Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
what is single quotation mark left side of cell for | Excel Discussion (Misc queries) | |||
In Excel can you select freeze pane and split screen on same page | Setting up and Configuration of Excel | |||
Single Column select | Excel Discussion (Misc queries) | |||
how do I "freeze" the left hand title column | Setting up and Configuration of Excel | |||
Select column cells to the left/right of active selection - an example | Excel Programming |