Convert object as string

[LTA]

Hi,

I am very new in macros and also on this forum and I need some help.

I have one column filled with several names. I want to loop in the column and check the first 2 letters(if are equal with string "In") from each name and after to put the names in a new column or in a new sheet or in a new workbook.

This is the code that I wrote until now:

Please Login or Register  to view this content.

How should I proceed to recognize the ActiveSheet.Range("C:C").Value as a string, so that to be able to work with strings after in the for loop?


Thank you very much for your help!

[LTA]

Hello all,

Anyone here who could help me ??

thanks a lot!

[johnjohns]

Why don't you do this with a filter. ie is Custom Autofilter->Begins with

rgds

johnjohns

[LTA]

Yes, but I need to select only values starting with "In" and I cannot do this with Custom filter.
Let me give example, to be more clear.
My column contains several values like:Atmel, AVX, Infineon, Avago, Microsoft, Kemet,...and so on.
I want to loop this column and for each cell to check which values start with "In"(for example Infineon) and to extract these values in a separate column.

Thank you!!

[johnjohns]

Can you post a sample w.book? Also see the attachment where I have done the filtering for all the values starting with "In"

rgds

johnjohns

[johnjohns]

Also your title do not match with your requirement. Please read the forum rules

rgds

johnjohns

[LTA]

Also your title do not match with your requirement. Please read the forum rules

rgds

johnjohns

Thank you for your Custom filter solution.
I attached a sample with a list.
What I was trying to do is to make the extraction using a macro.and I don;t figure out how to loop each value in each cell and to check the first two letters from each value. Because I cannot match an object with a string...this is the reason why my post is about convert an object to a string...Am I wrong?
I will try from now on to be very very specific with my title, because I already read the forum rules.
Thank you again for understanding and for help.

sincerely,
LTA

[johnjohns]

is it this way?

Please Login or Register  to view this content.

rgds

johnjohns

[LTA]

is it this way?

Please Login or Register  to view this content.

rgds

johnjohns

Yes, that is perfect. Thanks a lot! I consider this subject closed.
With respect,
LTA

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save