+ Reply to Thread
Results 1 to 4 of 4

VB Code to open and land at certain position when file is open

  1. 05-03-2016, 09:49 PM #1
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to open and land at certain position when file is open

    Hello:

    I need a VB Code to go to last occupied cell in column A in sheets "ClockInOut" when i open the excel file.
    Please let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  2. 05-03-2016, 10:14 PM #2
    djbomaha is offline
    Forum Contributor
    Join Date
    10-19-2012
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2010
    Posts
    249

    Re: VB Code to open and land at certain position when file is open

    Hi,

    Here is code that will activate the last cell with data in Column A when the workbook is opened.

    Please Login or Register  to view this content.
    Hope that helps,

    Dan
    Reply With QuoteRegister To Reply
  3. 05-03-2016, 10:25 PM #3
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: VB Code to open and land at certain position when file is open

    You might want to add the sheet name into make sure it goes to the bottom of the correct sheet

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  4. 05-04-2016, 07:29 AM #4
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VB Code to open and land at certain position when file is open

    Another:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VB Code to open and land at certain position
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2016, 11:31 AM
  2. Macro to Open window so that I can select the file i need to open, then copy paste values
    By AnalystMH in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2015, 08:14 PM
  3. A file iis found if I open Excel FIRST, but not if I open the file by double-clicking
    By Ed_Collins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2013, 01:52 AM
  4. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  5. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM
  6. when open e-amil report file, text import wizard open automatically
    By NICkman in forum Excel General
    Replies: 0
    Last Post: 06-25-2007, 11:56 AM
  7. [SOLVED] workbooks.open function fails to open an existing excel file when used in ASP, but works in VB.
    By san in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2006, 11:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1