Forum Discussion
baxatob
10 years agoCommunity Hero
No-no-no!
Just use VirtualItemsCount property instead of wRowCount
Colin_McCrae
10 years agoCommunity Hero
That will check a single row (using the single loop in your original snippet).
It you want all cells, you'll need a nested loop.
(Pseudocode)
Loop Rows (Using item count)
Loop Columns (Using column count)
Get Cell/Item Value(Row, Column)
End Columns Loop
End Rows Loop