Object item deletion conditionally

[devil_apps]

Hi,

I am writing a VBA code in which I am getting certain records in VBA Object.

The object contains around 1500 records (Item).

Is there any way that I can delete unwanted Items. For example, there is one field MESSAGE_TYPE in object. This field has value either "E" or "A". I want to delete records which has MESSAGE_TYPE = "A".

Is there a query or command through which I can delete all unwanted records without navigating whole 1500 items?

Thanks in advance,

 

[Andrew Poulsom]

You can AutoFilter for MESSAGE_TYPE = "A" then delete the visible records using SpecialCells(xlCellTypeVisible).

 

[devil_apps]

You can AutoFilter for MESSAGE_TYPE = "A" then delete the visible records using SpecialCells(xlCellTypeVisible).

Yes you are right.

But my data is in VBA Object (SAP Table factory control) and not in excel spreadsheet. I have to manipulate data in object first and then transfer it to excel.

 

[Andrew Poulsom]

Sorry, I know nothing about SAP Table Factory Control (this is an Excel forum).