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 ???
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 ???
![]()
Please Login or Register to view this content.
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
See below full code with which I'd like to apply highlighting ;![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Last edited by wanty; 06-02-2013 at 12:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks