Answer to Blog

Submitted by Vishesh on 15 January, 2012 - 15:02

This is the solution to blog on url
http://excelexperts.com/help

Please see attached xl file.

Attachment	Size
FindSum.xls	26 KB

Submitted by Anonymous on 16 January, 2012 - 07:37.

Hi,

Please tell me How to count the total number of excel sheets in a workbook

Submitted by Anonymous on 16 January, 2012 - 09:07.

NumberWorkSheets = thisworkbook.worksheets.count

Submitted by Anonymous on 17 January, 2012 - 12:07.

Not working

Submitted by Anonymous on 17 January, 2012 - 13:53.

how are you using it ?

.. if you have sheets other than worksheets, use Sheets.count

ExcelExperts.com