Why don't my Column widths match?

[MPW]

Hi All,

I am attempting to replicate column widths from one workbook to another.
Here is the line I wrote to do this.

For cc = 1 to 256
     newwkbk.Sheets(WSName.Columns(cc).ColumnWidth = _
     oldwkbk.Sheets(WSName.Columns(cc).ColumnWidth
Next cc

This should be enough to see what I am doing. If you need to see more I can provide it.

My problem is that even though the column width numbers are being carried over, the actual width of the columns dose not match.
I believe that my issue has to do with pixels vs millimeters but I am not sure. If this is the case how can I change the format of the new workbook match the format of the old? Failing that, can I convert the one into the other? For instance pixels into mm.

One more question: Why are different formats even used? It seems like it would make more sense to just use one.

Thanks

 

[shg]

You're welcome, good luck.