+ Reply to Thread
Results 1 to 6 of 6

Activesheet Method not working in my Macro

Hybrid View

  1. 11-16-2017, 07:58 PM #1
    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,644

    Re: Activesheet Method not working in my Macro

    Have you checked the active sheet is the one you want/think it is?

    You can easily do that in the Immediate Window with this.
    ? ActiveSheet.Name
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  2. 11-17-2017, 04:00 PM #2
    ankamshetti.nagaraj
    ankamshetti.nagaraj is offline
    Registered User
    Join Date
    08-30-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Activesheet Method not working in my Macro

    Hi Norie,

    I have checked it in the immediate window. it resulting the correct sheet name that what I want.
    Reply With QuoteRegister To Reply
  3. 11-20-2017, 06:53 PM #3
    ankamshetti.nagaraj
    ankamshetti.nagaraj is offline
    Registered User
    Join Date
    08-30-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Activesheet Method not working in my Macro

    Hi Norie,

    Did you got chance to look into my query ?
    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. Macro with activesheet reference stops working when worksheet is renamed
    By Naz555 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2017, 01:31 AM
  2. [SOLVED] Using the GetOpenFileName method to import sheets after activesheet
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2014, 07:48 AM
  3. Macro autofill stops working at Column AA? (method global failed)
    By Excel2010101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2014, 06:48 PM
  4. If activesheet.name not working
    By alexaa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2013, 12:11 AM
  5. ActiveSheet.Name not working?
    By schmidt62 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2012, 05:03 PM
  6. Location method with ActiveSheet
    By pierre_colin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 07:51 AM
  7. Macro working in background ie not on activesheet
    By Dynamiteskippy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2005, 11:05 PM

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