anything in Excel...

It's Excel-o-lozy...

Trick to count number of sheets / tabs in #MSExcel file / workbook without using VBA / Visual basic formula solution

www.Excelolozy.com - Without using VBA editor you can use this trick to count sheets in Excel file. In case you delete few sheets, VBA window won’t give true number of sheets.
So the trick is as follows:
> Select first sheet
> type in a blank cell “=CountA(”
> click on cell “A1”
> before hitting enter key hold down Shift key and click on last sheet
> note: formula reference would change.
> now hit enter.
Formula to Count sheets in Excelolozy by Vikrmn CA Vikam Verma author 10 Alone Chartered Accountant worksheet workbook file
 Formula to Count sheets in Excelolozy by Vikrmn CA Vikam Verma author 10 Alone
 Chartered Accountant worksheet workbook file 

Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com

Posted by Vikrmn: Author of "10 Alone" (CA Vikram Verma) 10Alone.com

0 comments: