| || |
Delete Row from GlobalDatasheet
i have a datatable that contains unique values. once i do an interation i want to delete the value that has been used so that it does not get used again. i have tried to use the datatable.GlobalSheet.DeleteRows method. this asks for two values which i assumed were the range of rows to be deleted. but what ever i supply to it i just get an error of object or property does not support this method.
any suggestions gratfully accepted
Re: Delete Row from GlobalDatasheet
DataTable object will not support deleterows method, but you can control this with a flag and use if condition to skip already used values.
RowCnt = DataTable.GetSheet("SheetName").GetRowCount
For i = 1 To RowCnt
If DataTable.Value("Run","SheetName")= "Y" Then