sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
Can someone please show me how to find a value in a range, (in this case E2:E20), and delete the value then shift the cells below it up?
I want to avoid deleting the whole row because the is other data within the sheet, and for these purposes the value to be found will be a textbox value on a userform.
I want to avoid deleting the whole row because the is other data within the sheet, and for these purposes the value to be found will be a textbox value on a userform.