+ Reply to Thread
Results 1 to 5 of 5

Problem with jumping to cell

  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Germany
    MS-Off Ver
    365
    Posts
    558

    Problem with jumping to cell

    Hi Guys

    I need a simple solution to jump from ActiceCell cell +200. E.g. ActiveCell is F19027, after running the macro, selected cell should be F19227

    Thanks !!

  2. #2
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Problem with jumping to cell

    Try:

    activecell.Offset(200,0).Select

  3. #3
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Germany
    MS-Off Ver
    365
    Posts
    558

    Re: Problem with jumping to cell

    Great ! Thank you ! How could I make the newly selected cell a new color, e.g. Interior.color = 10079487 ?

  4. #4
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Problem with jumping to cell

    Try,

    Please Login or Register  to view this content.
    HTH,
    Maud

  5. #5
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Germany
    MS-Off Ver
    365
    Posts
    558

    Re: Problem with jumping to cell

    Perfect ! Thanks again

+ 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. jumping to wrong cell
    By Donna Hoyland in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2016, 11:32 PM
  2. Replies: 1
    Last Post: 05-08-2014, 09:39 AM
  3. Jumping to the last cell of data
    By Tavelina in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2012, 07:02 AM
  4. [SOLVED] cell jumping
    By john456852 in forum Excel General
    Replies: 2
    Last Post: 08-23-2012, 12:25 PM
  5. Excel 2007 : How to Stop Cell Jumping?
    By lbohen in forum Excel General
    Replies: 1
    Last Post: 09-22-2009, 11:25 AM
  6. cell jumping
    By ali husain in forum Excel General
    Replies: 2
    Last Post: 01-14-2009, 04:13 AM
  7. Cell Jumping
    By OZROB in forum Excel General
    Replies: 1
    Last Post: 08-25-2005, 08:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1