I stand corrected. With the example I was using, it "seemed" to multiply.

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Width used with a range, returns the width of the range in points. It
doesn't
multiplying the sum of the column widths by the height of the range.

--
Regards,
Tom Ogilvy


"Don Guillett" wrote in message
...
That does it for height better than what I sent but it is multiplying
the
sum of the column widths by the height of the range. It is not giving
the
sum of the column widths.

--
Don Guillett
SalesAid Software

"Stan Scott" wrote in message
...
Stuart,

I'm using Excel 2002, but I don't think it makes a difference.

Range("myRange").Width
Range("myRange").Height

Return the information you need.

Stan Scott
New York City

"Stuart" wrote in message
...
What is the quickest way to return the overall width
(ie sum of columnwidths) and height (ie sum of
rowheights) for a range, please?