Results 1 to 10 of 10

Move from one row to specified row and column

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    48

    Move from one row to specified row and column

    Hello
    I made a macro to move one row content to another row and column and after I reinstal some programs, it doesn't work anymore.

    Sub muta()
    
    ' Muta centrul cercului in dreptul ultimei coordonate
    
    Dim Lr As Long, i As Long
    Lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To Lr
        With Range("A" & i)
            If LCase(.Value) Like "of" Then .Cut Destination = .Offset(-5, 10)
        End With
    Next i
    End Sub
    Anyway I want something like this:
    The macro search a row who it content the value "of" and it move the entire row content to the row -5 (up 5 rows) and the column 10
    Then it continues searching to the end of the rows.
    Last edited by RoMarius1981; 10-02-2013 at 04:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-23-2013, 06:19 PM
  2. [SOLVED] Seperate data in column A that has specific word and move to column B or C or D
    By jachbo in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-05-2013, 09:08 PM
  3. [SOLVED] Why does the formula move when I move the column
    By ag6 in forum Excel General
    Replies: 5
    Last Post: 04-21-2012, 04:56 PM
  4. Copy/move a word from a cell in a column to another column and autofill
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2009, 03:54 PM
  5. Replies: 2
    Last Post: 12-27-2005, 06:30 PM

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