on 02-18-2011 7:49 AM
Hi Experts,
I'm trying to delete rows in Goods Receipt PO where base line = PO LineNum e.g rowcount = 5 and I want to delete row 1 & 5.
I have tried using deleterow and activemenuitem.
For i = oMatrix.VisualRowCount To 1 Step -1
If oMatrix.Columns.Item("46").Cells.Item(i).Specific.value = POLine Then
oMatrix.DeleteRow(i)
'SBO_Application.ActivateMenuItem("1293")
End If
Next
The deleterow method will delete the row correctly but the column # is not in sequence after deletion and I cannot edit column #.
If I use ActiveMenuItem, my sequence will be corrected but it delete incorrect row because oMatrix.Columns.Item("46").Cells.Item(i).Specific.value is getting incorrect row.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
9 | |
8 | |
7 | |
7 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.