+ Reply to Thread
Results 1 to 2 of 2

Cut/paste array starting at preselected cell

  1. #1
    Registered User
    Join Date
    04-30-2004
    Posts
    78

    Cool Cut/paste array starting at preselected cell

    Cells in column D in my program have various data. I would like to have the user select any 0ne cell in that column and then have the macro select all cells starting with the selected cell down 100 cells and move the entire array down to start four cells below its original position. Help would be appreciated.
    Last edited by nebb; 12-24-2012 at 10:12 AM.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Cut/paste array starting at preselected cell

    Something like this, perhaps:

    Please Login or Register  to view this content.
    Last edited by Andrew-R; 12-22-2012 at 01:24 PM. Reason: Misread the requirements - fixed now

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1