Hi Sean,

Am Wed, 16 Nov 2016 06:22:05 -0800 (PST) schrieb :

One further twist I've just spotted, if I have only 2 Rows, your Autofill will show 0 in B3, instead of Blank, if I have 3 rows or more its perfect

Note on above A3 is empty

then search the last row in column T:

LRow = .Cells(.Rows.Count, "T").End(xlUp).Row


Regards
Claus B.
--
Windows10
Office 2016