Need Help Counting Blank Cells in a Dynamic Range

[monicamarie]

I'm trying to count all of the empty cells in a dynamic range but am having a hard time finding the correct code.
The example below shows how my data is laid out. The dynamic range is always in colum B. So one data list might end at B12 and another might end at B90 etc. I just want to count the number of empty cells and return the value in C2. Can someone help me with this as a VBA code?

Thank you

CARD NUMBER</SPAN>	CARDSTATUS</SPAN>
xxxxxxxxxxxx1234</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1235</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1236</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1247</SPAN>
xxxxxxxxxxxx1248</SPAN>
xxxxxxxxxxxx1249</SPAN>
xxxxxxxxxxxx1259</SPAN>
xxxxxxxxxxxx1260</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1265</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1266</SPAN>	ACTV</SPAN>
xxxxxxxxxxxx1267</SPAN>	ACTV</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

 

[Soggy]

Try:

Sub test()


lastrow = ActiveSheet.Range("A2").End(xlDown).Row
Range("C2").Formula = "=countblank(B2:B" & lastrow & ")"


End Sub

Cheers

Soggy

 

[monicamarie]

That worked! Thank you so so much!

 

[Soggy]

Your welcome.