+ Reply to Thread
Results 1 to 1 of 1

vba to doubleclick in a cell, row above is copied to row below, AND moves row below down

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    vba to doubleclick in a cell, row above is copied to row below, AND moves row below down

    Hello again! Further to my OP which has been solved (https://www.excelforum.com/excel-pro...e-example.html), it has come to my attention that if cells below the row that is doubleclicked upon to copy/paste row above is populated, could code push or copy/paste any cells populated below to be moved down one row to make room for the copy/paste from above? It could be one row or more that needs to be moved down. The form I have goes from R14-R28. Many thanks if someone could help with this! I can get the next row below to copy down one row, but can't figure out how to move more than one. I originally marked OP with this new development, but have now decided maybe better to start a new thread?
    Attached Files Attached Files
    Last edited by thecdnmole; 01-03-2019 at 02:59 PM.

+ 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. [SOLVED] vba when I doubleclick in a cell, row above is copied to row below, see example
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-03-2019, 11:54 AM
  2. Vba that moves cells with text, (up and to left, insert row/ insert copied cell)
    By sergi117 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2018, 03:12 PM
  3. [SOLVED] Change Macro that moves formula down 5 cells when rows are copied
    By Jamidd1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 07:06 AM
  4. [SOLVED] VBA -- DoubleClick on Cell with Value = 1
    By HighOctane in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-01-2015, 11:26 PM
  5. VBA Codes to DoubleClick a cell
    By JYY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2013, 01:21 AM
  6. When doubleclick a cell take action
    By vin1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2011, 05:00 PM
  7. What does DoubleClick on a cell do?
    By surotkin in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 08:51 AM

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