|
[Answered] Code loop through columns/rows for h/w |
Post Reply 
|
| Author | |
wakerunner 
Groupie 
Joined: 29 September 2007 Status: Offline Points: 85 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: [Answered] Code loop through columns/rows for h/wPosted: 06 April 2011 at 2:10pm |
|
Could anybody give me a pointer on the easiest way to loop through all columns and rows to get the height and width of each cell?
|
|
|
Product: Xtreme SuitePro (ActiveX) version 13.3.1
Platform: Windows 7 64 bit Language: Visual Basic 6.0 |
|
 |
|
|
wakerunner
Groupie
Joined: 29 September 2007 Status: Offline Points: 85 |
Post Options
Thanks(0)
Quote Reply
Posted: 06 April 2011 at 6:04pm |
|
I came up with this, there may be better ways but this works.
For C% = 0 To Ctrl.Columns.Count - 1
Cwidth = Ctrl.Columns(C%).Width Cwidth = Cwidth * Screen.TwipsPerPixelY For a% = 0 To Ctrl.Rows.Count - 1
Call Ctrl.Rows.row(a%).GetRect(T1, T2, T3, T4) Cheight = T4 - T2 Cheight = Cheight * Screen.TwipsPerPixelX Next a%
Next C% |
|
|
Product: Xtreme SuitePro (ActiveX) version 13.3.1
Platform: Windows 7 64 bit Language: Visual Basic 6.0 |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
![RSS Feed - [Answered] Code loop through columns/rows for h/w](forum_images/rss.png "RSS Feed: [Answered] Code loop through columns/rows for h/w")
Topic Options