Results 1 to 4 of 4

Thread: [RESOLVED] Worksheets() = Sheets() ?

  1. Nov 4th, 2013, 01:45 PM #1
    MartinLiss
    MartinLiss is offline

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [RESOLVED] Worksheets() = Sheets() ?

    Is there any difference at all in doing for example

    With Worksheets("Sheet1")

    as opposed to this?

    With Sheets("Sheet1")
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  2. Nov 4th, 2013, 03:41 PM #2
    vbfbryce
    vbfbryce is offline
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: Worksheets() = Sheets() ?

    "The Sheets collection includes all sheets in the workbook, chart sheets, sheets will cells, macro sheets, all sheets.
    The Worksheets collections includes only sheets with cells."

    http://www.ozgrid.com/forum/showthread.php?t=168770
    Reply With Quote Reply With Quote
  3. Nov 4th, 2013, 03:48 PM #3
    MartinLiss
    MartinLiss is offline

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: Worksheets() = Sheets() ?

    Thanks.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  4. Nov 4th, 2013, 03:53 PM #4
    vbfbryce
    vbfbryce is offline
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: [RESOLVED] Worksheets() = Sheets() ?

    No prob, I always wondered that as well!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width