Hi Mark

I don't understand exactly what you're trying to copy, from where and to where otherwise I'd have written some basic code for you.

To answer your question though, to recognise a blank cell you could try using:

Do
' Copy macro
Loop Until Activecell.Value = ""
If that doesn't help, maybe explain where a little more what you're trying to do and I'll see what I can do.

Dion