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

T De Villiers -

Use this formula to get the last row being used:
=MAX(IF(A1:A10000<"",ROW(A1:A10000),""))

Also, this is an array formula so enter it using ctrl+shift+enter.

Hope that helps.
--
Regards,
db


"T De Villiers" wrote:


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