Total width of selected columns?
 

Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column C?
In pixels or inches.

Would this also apply to rows?

Thank you.

Total width of selected columns?
 

Columns("A:C").Width returns the value in points

--
__________________________________
HTH

Bob

"sarah" wrote in message
...
Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column C?
In pixels or inches.

Would this also apply to rows?

Thank you.

Total width of selected columns?
 

Also, from your sheet you can enter the following formula

=Cell("width",A1)+Cell("width",b1)+Cell("width",c1 )

"sarah" wrote:

Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column C?
In pixels or inches.

Would this also apply to rows?

Thank you.