+ Reply to Thread
Results 1 to 3 of 3

ActiveWorkBook.ActiveSheet vs ActiveSheet

  1. 02-14-2019, 11:45 AM #1
    bvwalker1
    bvwalker1 is offline
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    113

    ActiveWorkBook.ActiveSheet vs ActiveSheet

    Any difference between these? If you use ActiveSheet, doesn't that assume you are already in the active workbook?
    Reply With QuoteRegister To Reply
  2. 02-14-2019, 12:01 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ActiveWorkBook.ActiveSheet vs ActiveSheet

    There's not difference between ActiveWorkBook.ActiveSheet and ActiveSheet.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 02-14-2019, 12:10 PM #3
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,237

    Re: ActiveWorkBook.ActiveSheet vs ActiveSheet

    It would only be different if the code is in the ThisWorkbook module of an inactive workbook.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] ActiveSheet.Name = ActiveSheet.Range("G1"), Worksheet_Calculate Event not working, 1004
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-28-2018, 11:24 AM
  2. ActiveWorkbook.ActiveSheet.SaveAs
    By HerBiz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2016, 07:58 PM
  3. [SOLVED] Undo "ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value" after copy
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2016, 06:35 AM
  4. ActiveSheet.PivotTables => How to do it for custom sheet? (replace ActiveSheet)
    By chrisignm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2014, 03:22 PM
  5. Insted f ActiveSheet.Range("$A$2:$E$1616") ActiveSheet.Range(" Whole area where data is")?
    By AbhijeetM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2013, 09:28 AM
  6. copy to activeworkbook activesheet - failed...
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2011, 10:58 AM
  7. Copying new activesheet after other activesheet is hidden?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 05:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1