+ Reply to Thread
Results 1 to 2 of 2

VBA code to insert line at top and bottom

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    1

    VBA code to insert line at top and bottom

    VBA gurus,

    I am in need of some help with a macro. I am trying to find some code for a macro that inserts a line above and below a set of values each time the value changes. For example, in the data set below, I need to insert a line before the UDWQ3 code string and after. Then i need it to move on to the next data set in the column (UUMC13) and do it again. Suggestions??

    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UDWQ3
    UUMC13
    UUMC13
    UUMC13
    UUMC13
    UUMC13
    UUMC13
    UUMC13
    UUMC13
    UVWTP
    UVWTP
    UVWTP
    UVWTP
    W00173
    W00177
    W00177
    W00177
    W06015
    W06015
    W06015
    W06015
    W06015
    W06015
    W06015
    W06015
    W06018
    W06018
    W06018
    W06023
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06024
    W06044
    W06044
    W07001
    W07001
    W07001
    W08005
    W08005

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VBA code to insert line at top and bottom

    Hi sbfedder

    Start from the bottom up
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. Excel 2007 : Bottom Line Getting Cut Off
    By Krisp42 in forum Excel General
    Replies: 4
    Last Post: 06-14-2013, 03:53 PM
  2. New Line at the bottom of a Table
    By CodeEnforcer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2013, 02:27 PM
  3. When I insert or delete line the code is not changing.
    By Anto_BT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2012, 01:30 PM
  4. Keepin total line (bottom line) static
    By milbogo in forum Excel General
    Replies: 1
    Last Post: 08-05-2008, 10:54 PM
  5. Insert two rows in one line of code?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2005, 12:40 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