+ Reply to Thread
Results 1 to 3 of 3

How to insert a row in last data entry?

  1. #1
    Registered User
    Join Date
    08-18-2007
    Posts
    62

    How to insert a row in last data entry?

    How can I record a macro to be use in a command button or after a particular cell the data has been enter to insert a row below the last cell with data? I have a table with dates and numbers that is use to plot several graphs and I would like to use a macro to insert a row automatically, so when next time to input a new date and numbers the macro will insert the row just below the last entry.

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    Would this help?

    Please Login or Register  to view this content.
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

  3. #3
    Registered User
    Join Date
    08-18-2007
    Posts
    62
    Jetted

    The code work work perfect!

    Thanks

+ Reply to Thread

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