Hi
have you tried Bob's suggestions (declaring the variables)?

--
Regards
Frank Kabel
Frankfurt, Germany


Rich wrote:
Sir,

it appeared in this line

rich


"Frank Kabel" wrote in message
...
Hi
what compile error in whhich line did you get?


cRows = Cells(Rows.Count,"A").End(xlUp).Row