Determining Column Width

[pspyve]

Hi Guys,
I know that there is a reason why excel is doing this, but I cant think why.
I need to find out the combined width of a number of consecutive columns.
Now if I set the column width of 20 columns to 2 it means that they have a combined width of 40, so if I set a column to 40 they should be the same width?
If I execute the following code:

Please Login or Register  to view this content.

And then visually compare the width of column V to the total width of columns A:T you can see, just by looking, that they are not the same size.
Now to prove this if I highlight row 1 and format it to "ARIAL" and font size 10 and type the following into range A1 "Microsoft Excel is a fun tio work with but has a few quirky things". Then type the exact same thing in cell V1 you can see that the text fits comfortably in the range A1:T1 but it overlaps over in cell V1.
My question is how do you determine the width of cells A1:T1.
Cheers
Phil

[pike]

Hi pspyve,
the column width is a inside measurement. The columns are the same just that the 20 by 2 width columns look big because they have 19 seperator lines between.

[pspyve]

Hi Pike,
What is the width then of a separator line? ie how much do I need to allow for this?

Cheers
Phil

[pike]

Hi pspyve

this works in xl2010

Please Login or Register  to view this content.

xlHairline is the default boarder/line

[pike]

nope that did work as expected ....
I'll google

[pike]

ok thinking about it the 20 by 2 cells merged width is 48
so 48 - 40 = 8
8/20= 0.4

Please Login or Register  to view this content.

[pike]

trial and error
The constant of 0.7 is very close

Please Login or Register  to view this content.

[pspyve]

Hi Pike,
I can see how you have overcome this problem. Thank you for your help. I will now be able to use this information and hopefully be able to carry on with the project. I just want you to know that this is critical to making our project work. many thanks for your input.

Cheers
Phil