Results 1 to 6 of 6

Jump to a cell and back??

Threaded View

ladi100 Jump to a cell and back?? 12-16-2013, 12:25 PM
ladi100 Re: Jump to a cell and back?? 12-16-2013, 12:35 PM
stnkynts Re: Jump to a cell and back?? 12-16-2013, 12:45 PM
ladi100 Re: Jump to a cell and back?? 12-16-2013, 12:52 PM
stnkynts Re: Jump to a cell and back?? 12-16-2013, 01:05 PM
ladi100 Re: Jump to a cell and back?? 12-17-2013, 05:30 AM
  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    7

    Jump to a cell and back??

    Hi all again

    So i have part fixed my previous problem with the following code:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row = 5 Then
    Target.Offset(55, 0).Select

    End If
    End Sub

    But basically I want users to enter data in cell B5 - then be taken down to the table (at around row 60) but have the cursor go back to B5 after so they can change the data for the table.

    So when they go back to B5 - the table remains visible as I have now frozen the pane at B5

    Any suggestions?
    Last edited by ladi100; 12-17-2013 at 05:31 AM. Reason: Solved query

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to copy a formula to a new cell and jump the cell reference more than one cell
    By sarkman22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2013, 08:00 AM
  2. How to jump to a different cell
    By singlec2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2012, 02:16 PM
  3. Need a Macro to Jump back to previous page
    By MD77614 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 02:48 PM
  4. Closing sheets as I jump back to main sheet
    By dollydoodah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2011, 09:45 AM
  5. [SOLVED] How do I double click a cell and jump to cell's referenced cell
    By JerryJuice in forum Excel General
    Replies: 2
    Last Post: 09-10-2005, 08:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1