Results 1 to 7 of 7

Macro to auto select adjacent cell then cell underneath

Threaded View

strud Macro to auto select adjacent... 06-21-2013, 04:29 AM
Debraj Roy Re: Macro to auto select... 06-21-2013, 05:08 AM
strud Re: Macro to auto select... 06-21-2013, 05:11 AM
nilem Re: Macro to auto select... 06-21-2013, 05:25 AM
strud Re: Macro to auto select... 06-21-2013, 05:36 AM
john55 Re: Macro to auto select... 06-21-2013, 05:43 AM
strud Re: Macro to auto select... 06-21-2013, 05:48 AM
  1. #1
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    297

    Macro to auto select adjacent cell then cell underneath

    I have used options to select the cell adjacent rather than underneath when hitting enter.

    However, I need this to be the case for column A, but for column B when the user hits enter I would like excel to jump straight bellow in column A.

    So they select A1, input data and hit enter- it jumps to B, input data and hit enter- jump to A2.

    I have it jumping to B1 but I'm not sure how to make the second jump.

    Maybe some sort of event macro..?
    Last edited by strud; 06-21-2013 at 05:04 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1