+ Reply to Thread
Results 1 to 5 of 5

Make this macro select active sheet

  1. 01-10-2013, 05:46 PM #1
    smugglersblues
    smugglersblues is offline
    Forum Contributor
    Join Date
    12-14-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    102

    Make this macro select active sheet

    How do I set this macro to the activesheet rather than a named sheet?

    Please Login or Register  to view this content.
    Last edited by smugglersblues; 01-10-2013 at 05:52 PM.
    Reply With QuoteRegister To Reply
  2. 01-10-2013, 05:50 PM #2
    ragavan.sridar1
    ragavan.sridar1 is offline
    Forum Contributor ragavan.sridar1's Avatar
    Join Date
    11-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010, Excel 2003
    Posts
    208

    Re: Make this macro select active sheet

    Just try using "Activesheet.select"
    Thanks!
    Raga.

    Please,mark your thread [SOLVED] if you received your answer.

    Click the little star * below, to give some Rep if you think an answer deserves it.

    I learnt so many things from these links.
    Reply With QuoteRegister To Reply
  3. 01-10-2013, 06:00 PM #3
    barryleajo
    barryleajo is offline
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: Make this macro select active sheet

    The sheet you are on is the ActiveSheet
    Therefore just delete or comment-out the reference to 
    Please Login or Register  to view this content.
    If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.
    Reply With QuoteRegister To Reply
  4. 01-10-2013, 07:11 PM #4
    smugglersblues
    smugglersblues is offline
    Forum Contributor
    Join Date
    12-14-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: Make this macro select active sheet

    barry your tip solved the problem. Thanks for the replies.
    Reply With QuoteRegister To Reply
  5. 01-10-2013, 07:18 PM #5
    barryleajo
    barryleajo is offline
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: Make this macro select active sheet

    Pleasure.
    Please mark your thread as SOLVED
    barry
    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)

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