Hi, Thanks to an earlier thread I have the folowing:

=countif(a1:a100,"")

but I need to vary the formula with the no of rows per data.

so if Row 123 is last row

I have = countif(a1:a123,"")

Maybe I can incorporate

LastRow = Cells(Rows.Count,1).End(xlUp).Row into this


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=398143