Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
width of Merged cells within un merged cells
Another one.. Assume cells e1,f1,g1 are merged (as are e2,f2,g2) up to e100 Same thing with cells in columns i,j,k Cells in the inbetween columns are NOT merged. I want to create a macro to size column width to 15 (each) of merged cells in column e,f,g. If I manually select the column in excel, I can do it.(ie click on the column letter) If I try to write basic VB to do (see below) it expands my column selection to the entire data iin the sheet(cols a - k) and then applies the column width to all of these columns (which I dont want) Unfortunately I cant unmerge the cols Any ideas??? Basic VB im using: Columns("E:G").Select Selection.ColumnWidth = 15 *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
width of Merged cells within un merged cells
Darin,
Columns("E:G").ColumnWidth = 15 worked for me.... -- HTH, Bernie MS Excel MVP "Darin Kramer" wrote in message ... Another one.. Assume cells e1,f1,g1 are merged (as are e2,f2,g2) up to e100 Same thing with cells in columns i,j,k Cells in the inbetween columns are NOT merged. I want to create a macro to size column width to 15 (each) of merged cells in column e,f,g. If I manually select the column in excel, I can do it.(ie click on the column letter) If I try to write basic VB to do (see below) it expands my column selection to the entire data iin the sheet(cols a - k) and then applies the column width to all of these columns (which I dont want) Unfortunately I cant unmerge the cols Any ideas??? Basic VB im using: Columns("E:G").Select Selection.ColumnWidth = 15 *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
width of Merged cells within un merged cells
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Excel - Automate row width for merged cells with wrapped text | Setting up and Configuration of Excel | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Merged cells width | Excel Programming | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |