$$Excel-Macros$$ VBA how to select specific characters from a string

2009-09-05 Thread ivavok
Hello, I need your help with VBA code. In one column I have several different objects and I need to copy only one of these (11,20,30,60,61) into another column. I have prepared this code: For counter = 0 To not_empty_cells For counter_dep = 1 To 5 position = InStr(1, (Cells(counter

$$Excel-Macros$$ VBA how to select specific characters from a string

2009-09-05 Thread ivavok
Hello, could somebody help me with this please? In one column I have different objects separated by a comma. I need to select one of these: 11,20,30,60,61 and copy it into another column. I have used this code: For counter = 0 To not_empty_cells For counter_dep = 1 To 5 position = I