Kenja824
Automotive
- Nov 5, 2014
- 950
I am trying to use VB Code to change the width to columns with specific Headers (in a table) to select which columns to change. My code already does an auto-fit for all columns, but there are a few columns I need to ignore the header width and shrink it to the width of the info in the cells.
The Header would be "Guage 1" for instance. All of the cells will only have....
0.60
1.20
1.50
0.85
In other columns I have a header "Matl 1"
But the info in the cells is no more than two letters
XG
XB
G
B
VG
etc....
I dont want a lot of space between the info for these two types of columns so I shrink them down to look like they belong together.