Ok i can't seem to figure this one out, im trying to do a .find in a dynamic range using the following statement:
For some reason it gives me a '1004' error, but if i do it trough a .select it works ok . Am i overlooking something ?, at first i was thinking of doing it this way:
Also gives me a '1004' error, its driving me crazy, why is this not possible, should i do it trough a select statement or is there an other way around, also tried to do it trough an cells(x,x).end(xlup) but also doesnt work. Cant seem to figure it out, can someone point me to my mistake ?
Thanks in advance, Jape,
Code:
Set rng4 = Sheets("TempC").Range("AY2", Range("AY65000").End(xlUp))
For some reason it gives me a '1004' error, but if i do it trough a .select it works ok . Am i overlooking something ?, at first i was thinking of doing it this way:
Code:
Sheets("TempC").Range("AY2", Range("AY65000").End(xlUp)).Find(rng2.Offset(0, 1).Value, LookIn:=xlValues, lookat:=xlWhole)
Also gives me a '1004' error, its driving me crazy, why is this not possible, should i do it trough a select statement or is there an other way around, also tried to do it trough an cells(x,x).end(xlup) but also doesnt work. Cant seem to figure it out, can someone point me to my mistake ?
Thanks in advance, Jape,