Thanks. The fact is that I must take variable names to work with them in an other process. Then, I must name the firts one as (f.ex) var1, the second var2, etc. The problems are that:
1) The number of variables can change, and for a file can be 3 and in the next can be 10
2) The variables are repeted in the column, then, when the name of variable 1 is in A1, the variable 2 can be in A14 and the variable 3 in A150 maybe... the only thing I know is that the variables are in alphabetical order, so I need the macro to travel across the column and asign var1 to the first name, var2 to the second, etc.
This is the table where I'm working:
Range("A:A") is:
BORMIOLI
BORMIOLI
BORMIOLI
BORMIOLI
CALP
CALP
CHURCHILL
CHURCHILL
CHURCHILL
CHURCHILL
etc...
And I need:
var1 = BORMIOLI
var2 = CALP
var3 = CHURCHILL
Thanks!!