:06:05 PM
Subject: $$Excel-Macros$$ Count Number of Records in worksheet
Hi,,
Please tell me how to count the number of total records in a worksheet using
the
macro or count of non blank cells in a worksheet.
--
Thanks and Regards,
Jitendra Kr. Verma| Sr. Software Engineer
Mob: +91.9700695633
Dear Jitendra,
Simply palce the cursor in any other worksheet.
for example if you want to count the number of nonblank cells in sheet1,
just place the cursor anywhere in sheet2 and =COUNTA(Sheet1!1:65536)
Thanks & Regards
Thamu
On Wed, Jan 26, 2011 at 11:43 PM, Dilip Pandey wrote:
> Hi Jit
Hi Jitendra,
Not sure how you have arranged the data into your worksheet, but try
below code:-
Sub lastRec()
i = Range("a65536").End(xlUp).Row
MsgBox i-1 'subtract one from i if you have the headers at top
End Sub
To count non blank cells in a worksheet, you can use COUNTA function.
Please ge
Hi,,
Please tell me how to count the number of total records in a worksheet using
the macro or count of non blank cells in a worksheet.
--
*Thanks and Regards,*
Jitendra Kr. Verma| Sr. Software Engineer
Mob: +91.9700695633
--
