Are you wanting to count the sheets
or count the records/rows on all sheets?
Sheets.Count
gets you the number of sheets.
For Sht = 1 to sheets.count
total = total
+ application.worksheetfunction.counta(sheets(sht).range("A1:A65000"))
next Sht
would loop through all sheets and count the number of non-blank cells in column
"A".
??
Paul
________________________________
From: Prathima R <prathima....@gmail.com>
To: excel-macros@googlegroups.com
Cc: ashish koul <koul.ash...@gmail.com>
Sent: Thu, February 10, 2011 6:21:43 AM
Subject: $$Excel-Macros$$ Need Help
Hi,
i have multiple sheets and i want to count the number of instruments in one go,
with COUNTA am not able to get. I tried grouping the sheets but could't get the
count of all sheets.
need your suggestion
Thanks,
Prathima--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
