Its ok for me for this problem. Thank you
Its ok for me for this problem. Thank you
Last edited by rosamoreno; 03-04-2021 at 07:25 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Please Login or Register to view this content.
Sorry it didnt work out for me.
It deletes everything but the first component of the list, in this case "3-methylbutanal".
Thank you
Ahh, should be like this.
Please Login or Register to view this content.
Also ok.... Personal info
Last edited by rosamoreno; 03-04-2021 at 07:25 AM.
Please Login or Register to view this content.
Sorry it doesn't work out for me...I still have components that are not present in my list. i'll also like to keep only components that contain the exact same word
please find attached my script
Thank you very much !Please Login or Register to view this content.
..................
Last edited by jindon; 03-04-2021 at 07:16 AM.
is it possible to delete the last post ? my problem here is a bit different.
Thankk you !
How is it different?
Why are you using my code there?
Those codes are originated by your first thread
https://www.excelforum.com/excel-pro...ions-rows.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks