Home » Blogs » Vishesh's blog

Answer to Blog

Vishesh's picture
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.

AttachmentSize
FindSum.xls26 KB
»

Count of Excel sheets in workbook

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

»

NumberWorkSheets =

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

NumberWorkSheets = thisworkbook.worksheets.count

»

Not working

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

Not working

»

how are you using it ? .. if

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

how are you using it ?

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

»