Thread
:
Height + Width of a Range
View Single Post
#
7
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Height + Width of a Range
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?
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]