+ Reply to Thread
Results 1 to 2 of 2

Moving A Cell Up Two Rows Using Macro/VBA/Code

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    England
    MS-Off Ver
    2011
    Posts
    5

    Moving A Cell Up Two Rows Using Macro/VBA/Code

    Hello All,

    I want to be able to move a cell using code.

    The cell has a defined name of CELLTOBEMOVED

    How would I go about moving CELLTOBEMOVED and its contents up two rows.

    This must be done using a macro/code referring to the cell name as it isn't always in the same location (It may be A1, A28, A36 etc etc.)

    Thanks for any help

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,617

    Re: Moving A Cell Up Two Rows Using Macro/VBA/Code

    Please Login or Register  to view this content.
    shall do the trick

    of course A1 cannod be moved up and will return an error. So if you expect A1, then you shall check current location first :-)
    Best Regards,

    Kaper

+ 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. VB code for Moving Rows up and down
    By AndyR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2017, 05:28 AM
  2. [SOLVED] Help with code syntax for moving rows
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-20-2016, 06:55 PM
  3. Code for moving rows of data automatically from one worksheet to another not working
    By Kashyap_17 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2014, 08:17 AM
  4. Macro to copy rows based on moving date and paste the rows into an identical sheet
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 11:59 AM
  5. Macro code for moving between files
    By Shift-4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 08:53 PM
  6. Moving Rows and Columns with a Macro
    By mtcnd2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-27-2009, 04:28 PM
  7. Macro for moving rows?
    By MCOInvid in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-07-2005, 08:03 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