+ Reply to Thread
Results 1 to 6 of 6

if workbook inactive for 30sec make last empty cell in column b the active cell

  1. #1
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    if workbook inactive for 30sec make last empty cell in column b the active cell

    hi
    To all you excel gods

    how to make workbook if inactive for eg (30sec) make last empty cell in column b the active cell would much appreciate any help and time with this subject

    cheer

    shane

  2. #2
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: if workbook inactive for 30sec make last empty cell in column b the active cell

    hi all i have manage to find a little code but im not sure how to make it call the last emtpy cell in column b

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: if workbook inactive for 30sec make last empty cell in column b the active cell

    Hi ssperyer,

    In ThisWorkbook module, place this code :

    Please Login or Register  to view this content.
    In an other module, place this code :

    Please Login or Register  to view this content.
    Change the sheet as per your workbook.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  4. #4
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: if workbook inactive for 30sec make last empty cell in column b the active cell

    hi thanks alot for your GC excel
    help you legend!!
    there only one little problem it goes the last filled cell in column b not the next empty cell in column b

    cheers
    shane

  5. #5
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: if workbook inactive for 30sec make last empty cell in column b the active cell

    Small change :

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: if workbook inactive for 30sec make last empty cell in column b the active cell

    GC EXCEL THANK YOU LEGEND!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WORKS PERFECTLY!!!!!

+ 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. Copy values from cell in active row, paste in first empty cell in spesified column.
    By Test123Test in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2012, 05:20 PM
  2. Make buttons active or inactive
    By wessel.cronje in forum Excel General
    Replies: 2
    Last Post: 10-07-2011, 04:20 AM
  3. Make buttons active or inactive
    By wessel.cronje in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2011, 11:19 AM
  4. Replies: 2
    Last Post: 04-21-2009, 11:15 AM
  5. Copying from one cell, into the next empty cell in column A in another workbook
    By Grangey in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 08-06-2008, 04:13 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