+ Reply to Thread
Results 1 to 4 of 4

Return to starting cell after macro completes

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    Los Angeles
    MS-Off Ver
    2007
    Posts
    14

    Return to starting cell after macro completes

    I made a filter macro. But when I run it, it ends up putting me on a totally different part of the screen and then I have to go back and find my place again. Is there a VBA code that allows me to go back to the cell I was in when I push the macro button once the macro is finished?

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Return to starting cell after macro completes

    simple use this :

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    11-04-2014
    Location
    Los Angeles
    MS-Off Ver
    2007
    Posts
    14

    Re: Return to starting cell after macro completes

    Thanks, but what if I was not on cell a10, but on cell a227? Can I make it dynamic so somehow it remembers where I was and then puts me back there?

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,538

    Re: Return to starting cell after macro completes

    At the beginning of the code:
    Please Login or Register  to view this content.
    'Your code here

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. return every 4th row from different starting cell
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2014, 12:30 AM
  2. Save VBA errors & report them after macro completes
    By Philb1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2013, 01:00 AM
  3. How to return sum of a range with fixed starting cell and variable length
    By jaskeerat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2011, 05:00 AM
  4. Pausing macro until .xla function completes
    By rtylerdunn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2007, 05:57 PM
  5. Macro - Return to starting cell
    By sony654 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-26-2006, 05:00 PM

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