I tried your code which unfortunatly did'nt work, Iwas getting an error
message I tried leaving out the & in the (NextRow&) piece of code as the
debugger was pointing to that line , tried running it again and it told me it
failed on Pastespecial so now I'm lost, but thanks for trying