+ Reply to Thread
Results 1 to 2 of 2

Different between ActiveWorkbook.Sheet and ActiveWorkbook.WorkSheets

  1. #1
    Registered User
    Join Date
    02-16-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    78

    Different between ActiveWorkbook.Sheet and ActiveWorkbook.WorkSheets

    Hi,

    can anyone please tell me the difference between the following lines of code

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    I am using both in my projects and I really donno when which one will work since there should be difference...

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Different between ActiveWorkbook.Sheet and ActiveWorkbook.WorkSheets

    The .Sheets collection includes the Chart Sheets in a workboook.
    The .WorkSheets collection is only the worksheets (sheets with cells).

    .WorkSheets is a sub-set of .Sheets (it is not a property of the .Sheets collection)
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1