It counts the number of non-blank cells in the row pointed at by the
variable r.

--

HTH

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

"Raj" wrote in message
...
Hi

It works fine. Thank you so much for the much needed
support. But would you tell me what does this line mean
actually.
Application.CountA(Rows(r))

Regards