Thread
:
Height + Width of a Range
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Height + Width of a Range
glad to help
--
Don Guillett
SalesAid Software
"Stuart" wrote in message
...
Many thanks to you both.
Regards.
"Bob Flanagan" wrote in message
...
Stuart, something like
rh=0
for each oRow in selection.rows
rh = rh + oRow.RowHeight
Next
I leave as an exercise the same code for column height!
Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB
macros for Excel
"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?
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com)
.
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com)
.
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]