thanks for advice, but i get an Compile error that highlights Lastrow saying
"sub or function not defined"


Peo Sjoblom wrote:
Oops! I forgot to paste the link

http://www.rondebruin.nl/copy2.htm

What would be the VBA code for this one?

[quoted text clipped - 5 lines]
9 10 11 12
. .