![]() |
[Answered] Code loop through columns/rows for h/w |
Post Reply ![]() |
Author | |
wakerunner ![]() Groupie ![]() Joined: 29 September 2007 Status: Offline Points: 85 |
![]() ![]() ![]() ![]() ![]() Posted: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |