LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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





 
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:57 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"