Hi.
I want to search a table for a value and when the value is found, to delete the row .
I tried the code below , but I got index error
-------
f = table1.RowCount -1
for j = 0 to f
If table1.Cell("Car",j) = 5 Then
table1.RemoveRow(j)
f = f - 1
End If
next
-------
Is there a beter way to do it ?
Thanks
Sefi.
I want to search a table for a value and when the value is found, to delete the row .
I tried the code below , but I got index error
-------
f = table1.RowCount -1
for j = 0 to f
If table1.Cell("Car",j) = 5 Then
table1.RemoveRow(j)
f = f - 1
End If
next
-------
Is there a beter way to do it ?
Thanks
Sefi.