Natsha
New Member
- Joined
- May 20, 2021
- Messages
- 44
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I need an macro to delete the value which I find ...Example , I have data in coloum A and B, with header and data start in A2 and B2 and extend .
Starting from column B2 ,I have values like 1-6;3-8;12-6 ..etc. I eed an macro where I can remove particular value I type in textbox by find option and deleted it with deleting other data in the cella
Example B2 has 1-6;3-8;12-6;9-9 ,I want to remove ;9-9, after I paste the value in textbox it should remove ;9-9 and change into 1-6;3-8;12-6;
I Need macro where I can select the cells that datas need to be removed. Column B is the default column containing datas
Note: The value I need to delete changes everytime like, ;1-1 or 8-9; or 12-13;
kindly help.
Starting from column B2 ,I have values like 1-6;3-8;12-6 ..etc. I eed an macro where I can remove particular value I type in textbox by find option and deleted it with deleting other data in the cella
Example B2 has 1-6;3-8;12-6;9-9 ,I want to remove ;9-9, after I paste the value in textbox it should remove ;9-9 and change into 1-6;3-8;12-6;
I Need macro where I can select the cells that datas need to be removed. Column B is the default column containing datas
Note: The value I need to delete changes everytime like, ;1-1 or 8-9; or 12-13;
kindly help.