I am using a macro to size column to specific dimension as below.
The problem is when I execute the code all three columns (column B, C and D) become the same size which is "23" or in other word it gets the last column size in macro which is 23 in above code.![]()
Please Login or Register to view this content.
I believe the cause of this is merged cell, in my table in column B, C and D, I have few merged cell i.e. B5 is a merged cell combining B5+c5+D5 cell.
Is there a way I can make this macro work? any suggestion?
Thanks in advance,
Anand
Bookmarks