Skip to Content
0
Former Member
Feb 18, 2011 at 07:49 AM

How to delete rows in system matrix

413 Views

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,