LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ake Ake is offline
external usenet poster
 
Posts: 18
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is single quotation mark left side of cell for Stache02 Excel Discussion (Misc queries) 4 January 11th 08 09:19 PM
In Excel can you select freeze pane and split screen on same page Jeannie Setting up and Configuration of Excel 2 August 3rd 07 06:29 PM
Single Column select Daniel Q. Excel Discussion (Misc queries) 4 October 18th 06 10:07 PM
how do I "freeze" the left hand title column DDAANN Setting up and Configuration of Excel 4 February 26th 06 12:21 PM
Select column cells to the left/right of active selection - an example [email protected] Excel Programming 1 March 24th 05 06:36 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"