application.countblank(range("A1:H10"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sanka" wrote in message
...
How to get the number of Blanks rows in a range in VBA