+ Reply to Thread
Results 1 to 2 of 2

Change vba from move EntireRow to moving 1 cell

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    Change vba from move EntireRow to moving 1 cell

    I have a piece of code that moves an entire row to the bottom of the data and then moves the whole data up by 1. Basically it cycles the data when you click a button. However, because of an audit trail that only picks up changes made to one cell, I need to change this code so that it does the following:

    'A3' moves to end of data. Data shifts up by one.

    My current code which moves entire row is:

    Please Login or Register  to view this content.
    Basically, just moving one cell instead of the entire row.

    Thanks in advance!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,317

    Re: Change vba from move EntireRow to moving 1 cell

    Check it out.

    Please Login or Register  to view this content.

+ 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] Move ActiveCell.EntireRow to another sheet
    By chriskay in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-01-2019, 08:12 AM
  2. [SOLVED] Macro to copy a cell, paste it to another sheet, then move down, without moving formulas
    By ahalliwell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2017, 07:40 AM
  3. [SOLVED] Moving a cell on a worksheet does not move reference in VBA
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2016, 04:29 PM
  4. [SOLVED] Change from Entirerow to Column range
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-25-2013, 04:07 AM
  5. Change from Entirerow to Column range
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2013, 08:06 AM
  6. [SOLVED] Change/replace vb code .EntireRow.Insert (2007)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2012, 07:46 AM
  7. change vba from EntireRow to Column.Range
    By Nogi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2007, 06:28 AM

Tags for this Thread

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