Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi can someone help on a delete rows vba code
I need to delete all rows that contain the following, it checks column D for the data on Sheet
I need to delete all rows that contain the following, it checks column D for the data on Sheet
- #VALUE!
- More than 1 hyphen eg. Crocs-Womens-Shoes this no good, if there is 1 hyphen then leave that row
- Numbers, these will be 3 or more numbers in a string /14768/ this is no good. However Crocs Shoes14768 or something like Crocs-Shoes147 is fine