+ Reply to Thread
Results 1 to 3 of 3

vba to insert new row AND highlight NEWLY INSERTED ROW

  1. 06-01-2013, 08:26 PM #1
    wanty
    wanty is offline
    Registered User
    Join Date
    11-12-2007
    Posts
    38

    vba to insert new row AND highlight NEWLY INSERTED ROW

    Is it possible to not only use vba to insert a new row in a sheet, copy down the formula and formats from the row above the newly inserted row BUT TO ALSO HIGHLIGHT the NEWLY inserted row so that it stands out ???
    Reply With QuoteRegister To Reply
  2. 06-01-2013, 11:40 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: vba to insert new row AND highlight NEWLY INSERTED ROW 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-01-2013, 11:56 PM #3
    wanty
    wanty is offline
    Registered User
    Join Date
    11-12-2007
    Posts
    38

    Re: vba to insert new row AND highlight NEWLY INSERTED ROW

    Thanks Alpha, what I would really like to apply this to is the code below so that any new row inserted becomes highlighted, copies both the formatting and formulas down from the copied row and stands out clearly;

    copied row example, line 10 in full code at the bottom of page

    Please Login or Register  to view this content.
    See below full code with which I'd like to apply highlighting ;


    Please Login or Register  to view this content.
    Last edited by wanty; 06-02-2013 at 12:00 AM.
    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)

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