Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
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 |