Hi Frank,

Am Mon, 3 Aug 2015 12:01:17 +0100 schrieb F:

Trying hard to educate myself... would
Set dest = Range("C36").End(xlUp)(2)
do what I want?

not if you have data in C1:C40.
Then it will find C41


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional