View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Return Row Heights for Rows in Active Worksheet - an example

Hi DataFreak,


Note: this procedure only seems to return the row heights for row
numbers 1-32765.
After this row, the report just jumps to row number 65536 and the
row's corresponding height. I'm using Excel 2000 on Win 2000 Pro.
The procedure seems to want to deliver row heights for just the first
"half" of the rows in the target (active) worksheet. Oh well. If
anyone has any thoughts, please do tell. :)



This is because you declare your variable row as integer - try changing to
long.

---
Regards,
Norman