Ottsel
Board Regular
- Joined
- Jun 4, 2022
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
Struggling to make a for loop that'll delete a cell in column A if it doesn't contain the word "Lot" amongst the string of text.
Example:
G:\JOBCARDS\ADS\ERT\ADSERT78-85PHS11-PC5.xls
The following above would be deleted, since it doesn't contain the word "Lot" within it
G:\JOBCARDS\ADS\ERT\Lot2032.xls
This row would remain, since it does contain the word "Lot"
Example:
G:\JOBCARDS\ADS\ERT\ADSERT78-85PHS11-PC5.xls
The following above would be deleted, since it doesn't contain the word "Lot" within it
G:\JOBCARDS\ADS\ERT\Lot2032.xls
This row would remain, since it does contain the word "Lot"
Last edited: