hello, ,,,sorry if i bother again, but the las tip you gave me works excellent.....now i got an issue regarding to that...i have this code:
Dim t
For t = 1 To last_counter
t = t + 1
Windows("Frisa.xls").Activate
xc = Application.WorksheetFunction.Match(ter, Range("A:A"), 0)
....etc
I need the counter "ter" (in this case, would be = 2),find for the "ter" value (number 2) in the range resulting in the rownumber where the value of ter is.
But is not working!....when I run the code, appears an error and ter with the value of 3 (or if i change to another var, i.e just t appears 4)...so please,,i will appreciatte your help again
Dim t
For t = 1 To last_counter
t = t + 1
Windows("Frisa.xls").Activate
xc = Application.WorksheetFunction.Match(ter, Range("A:A"), 0)
....etc
I need the counter "ter" (in this case, would be = 2),find for the "ter" value (number 2) in the range resulting in the rownumber where the value of ter is.
But is not working!....when I run the code, appears an error and ter with the value of 3 (or if i change to another var, i.e just t appears 4)...so please,,i will appreciatte your help again