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