ok i have got a debugger problem. with the line:

With Sheets("prem_gates").Columns("A:A")

it seems not to like the With i think. cause when i made it:

Sheets("prem_gates").Columns("A:A")
Set Villa = .Find("Aston_Villa")

it then found a problem with .find

so how can i get round this new problem?


--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile: http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=390019