Delete rows if column "A" has specific text

[MohammedAsif10000]

Hello,
See attached excel and screenshot.
I want macros/vba to delete complete rows when column "A" has "Ax.Services.Data.DCAssetBaseABC", "Ax.Services.Data.DCContractArgsCDA", "Ax.Services.Data.DCAssetBaseXYZ" (the list is more) etc...

ForumExcludeItems.xlsx
ForumExclude.PNG

[rollis13]

Have a try with what I came up; to be pasted in a vbe module and used on the active sheet:

Please Login or Register  to view this content.

[MohammedAsif10000]

If I add more items in Array (), it is giving error!! Is it because of many items?

[rollis13]

No, in truth there is a limit but it's a very big number. Did you use the exact syntax ? please show your current array because your problem is probably the limit of the lenght of line in VBE. In this case you have to split your line with an underscore _ just after a comma ,

[MohammedAsif10000]

Yes after using _ it works

[rollis13]

Thanks for the positive feedback , glad having been of some help.