Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to adjust column width
I am not a programmer but that doesnt seem to take into account the values in
row 8. It will come in handy for something else though. Cheers Primed "Rick Rothstein" wrote: Why not let VB figure it out for you... Columns("E:AI").AutoFit -- Rick (MVP - Excel) "primed" wrote in message ... Hi, Can anyone help with code to do the following: Row E8:AI8 - each cell contains a value 0 to 100, generally a value of 1 to 20. The total of the row is maximum 100. I would like to adjust the width of the column based on the values for each column. The minimum width would need to be 6 so text is still readable. Thanks in advance Primed . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to adjust column width
I'm not sure why you say that... the code line I posted sizes each column in
the range to the contents of the widest value in the column (which, unless I completely misunderstood what you were asking for, I believe is what your initial posting was suggesting you wanted to do). If you didn't already do so, give it a try and see how it works. -- Rick (MVP - Excel) "primed" wrote in message ... I am not a programmer but that doesnt seem to take into account the values in row 8. It will come in handy for something else though. Cheers Primed "Rick Rothstein" wrote: Why not let VB figure it out for you... Columns("E:AI").AutoFit -- Rick (MVP - Excel) "primed" wrote in message ... Hi, Can anyone help with code to do the following: Row E8:AI8 - each cell contains a value 0 to 100, generally a value of 1 to 20. The total of the row is maximum 100. I would like to adjust the width of the column based on the values for each column. The minimum width would need to be 6 so text is still readable. Thanks in advance Primed . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to adjust column width
Hi Rick,
Probably my poor communication skills are the issue. Columns E to AI need to be resized based on values in row 8 only. Other rows contain data that needs to be ignored. Your formula seems to resize the columns based on the value in all the rows. Regards Primed "Rick Rothstein" wrote: I'm not sure why you say that... the code line I posted sizes each column in the range to the contents of the widest value in the column (which, unless I completely misunderstood what you were asking for, I believe is what your initial posting was suggesting you wanted to do). If you didn't already do so, give it a try and see how it works. -- Rick (MVP - Excel) "primed" wrote in message ... I am not a programmer but that doesnt seem to take into account the values in row 8. It will come in handy for something else though. Cheers Primed "Rick Rothstein" wrote: Why not let VB figure it out for you... Columns("E:AI").AutoFit -- Rick (MVP - Excel) "primed" wrote in message ... Hi, Can anyone help with code to do the following: Row E8:AI8 - each cell contains a value 0 to 100, generally a value of 1 to 20. The total of the row is maximum 100. I would like to adjust the width of the column based on the values for each column. The minimum width would need to be 6 so text is still readable. Thanks in advance Primed . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to adjust column width
Ah, I missed the Row 8 part. Give this a try then...
Range("E8:AI8").Columns.AutoFit -- Rick (MVP - Excel) "primed" wrote in message ... Hi Rick, Probably my poor communication skills are the issue. Columns E to AI need to be resized based on values in row 8 only. Other rows contain data that needs to be ignored. Your formula seems to resize the columns based on the value in all the rows. Regards Primed "Rick Rothstein" wrote: I'm not sure why you say that... the code line I posted sizes each column in the range to the contents of the widest value in the column (which, unless I completely misunderstood what you were asking for, I believe is what your initial posting was suggesting you wanted to do). If you didn't already do so, give it a try and see how it works. -- Rick (MVP - Excel) "primed" wrote in message ... I am not a programmer but that doesnt seem to take into account the values in row 8. It will come in handy for something else though. Cheers Primed "Rick Rothstein" wrote: Why not let VB figure it out for you... Columns("E:AI").AutoFit -- Rick (MVP - Excel) "primed" wrote in message ... Hi, Can anyone help with code to do the following: Row E8:AI8 - each cell contains a value 0 to 100, generally a value of 1 to 20. The total of the row is maximum 100. I would like to adjust the width of the column based on the values for each column. The minimum width would need to be 6 so text is still readable. Thanks in advance Primed . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Width: cannot adjust | Excel Discussion (Misc queries) | |||
column width will not adjust | Excel Worksheet Functions | |||
Adjust column width | Excel Discussion (Misc queries) | |||
Adjust Column Width? | Excel Discussion (Misc queries) | |||
Using Code to Adjust Specific Column Width | Excel Programming |