column width macro in merged cell seems to have problem

I am using a macro to size column to specific dimension as below.

Please Login or Register  to view this content.

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.

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