Conditionally delete rows in currentliy selected table
On the currently selected table I would like to perform the following actions using VBA
The macro is to loop thru the first column of the selected table and look for the term 'error' there. If found the whole row is to be deleted. Of course there could be many cells in the first column where this term 'error' occurs.
Help is much appreciated. Thank you very much in advance.
With MS Excel, you can use the delete methode of the range object.
Open in new window
With Access, you can use a query.