GetROProperty returns unexpected value

[parminderdhiman84]

Hi,

Please try replacing the above For Loop with one of the following for loops. One of them should work for u:

Code:

For i=0 to cnt_tb-1
no_cols=objColl.item(i).getroproperty("cols")
If no_cols=2 Then
data_tab=objColl.item(i).getcelldata(3,2)
msgbox data_tab
End If
Next

or

Code:

For i=0 to cnt_tb-1
no_cols=objColl(i).getroproperty("cols")
If no_cols=2 Then
data_tab=objColl(i).getcelldata(3,2)
msgbox data_tab
End If
Next

or

Code:

For i=1 to cnt_tb
no_cols=objColl(i).getroproperty("cols")
If no_cols=2 Then
data_tab=objColl(i).getcelldata(3,2)
msgbox data_tab
End If
Next

If still the error comes then could u debug to check that "cnt_tb" is returning any value or not.