+ Reply to Thread
Results 1 to 3 of 3

VBA Help Insert Row Retain Formatting

  1. #1
    Registered User
    Join Date
    05-04-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    33

    VBA Help Insert Row Retain Formatting

    Hi - the code below adds an empty row to the bottom of my Table 3 ready for a new line of data entry in Cols B to H.

    My table has data that's indented from the Left Margin for clarity.
    My problem - every time I add a new line (with VBA below) for my new entries, the indentation progressively increases from the left margin making my entries advance to the right.
    My request - can anyone suggest an addition to the code below that will retain the formatting of the first row in my table, or the formatting of the row last row of data?
    Or something like ... Application.OnEntry = "indent entries once from the left border in cols B to H"

    Presently I have this code:
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,021

    Re: VBA Help Insert Row Retain Formatting

    I tried it here on another list, but didn't have your problem, so this is a guess.
    Please Login or Register  to view this content.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    05-04-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: VBA Help Insert Row Retain Formatting

    Thankyou bsavl!

+ 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. Need to allow users to insert a row to a table, but retain the formulas
    By jayhawk71 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-17-2015, 10:03 PM
  2. How to retain formatting
    By Trojnfn in forum Excel General
    Replies: 1
    Last Post: 04-15-2014, 11:33 AM
  3. Insert Word Document with a macro, retain original formatting
    By dwhims in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2013, 06:05 PM
  4. Retain Formatting
    By xjenniex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-13-2013, 12:10 PM
  5. Replies: 2
    Last Post: 12-18-2012, 05:22 AM
  6. Insert new row into invoice and retain formulas and formatting
    By korrigan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2010, 05:48 AM
  7. Retain formatting during concatenation
    By NoCanDo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2009, 03:15 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