Results 1 to 9 of 9

vba find text , move entire cell to the same row column C

Threaded View

sausis vba find text , move entire... 10-06-2015, 10:09 AM
alansidman Re: vba find text , move... 10-06-2015, 10:22 AM
vichopalacios Re: vba find text , move... 10-06-2015, 04:25 PM
sausis Re: vba find text , move... 10-06-2015, 05:31 PM
vichopalacios Re: vba find text , move... 10-07-2015, 12:40 PM
sausis Re: vba find text , move... 10-08-2015, 04:10 AM
skywriter Re: vba find text , move... 10-07-2015, 05:57 PM
vichopalacios Re: vba find text , move... 10-07-2015, 08:08 PM
sausis Re: vba find text , move... 10-08-2015, 04:12 AM
  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Vilnius
    MS-Off Ver
    Excel 2010
    Posts
    8

    vba find text , move entire cell to the same row column C

    I have macros, which search word "abc" in column D, the move this cell to column C:

     
    Sub MoveDataD()
    Dim myrange, cell As Range
    Set myrange = ActiveSheet.Range("D1:D500")
    For Each cell In myrange
        If Left(cell.Value, 3) = "abc" Then
          cell.Offset(0, -1).Value = cell.Value
            cell.ClearContents
            End If
    Next cell
    End Sub
    I need the same only search range must be all active columns starting from D , e.g. D1:W5000. All found cells should move to column C.
    Last edited by sausis; 10-06-2015 at 10:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find the last used cell in a row and move to a column in the same row - Move to next row
    By usafmeinweg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 02:42 AM
  2. Find Text in Column then Move
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2014, 04:34 PM
  3. Find Text in Column then Move
    By Grahamfeeley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2014, 02:44 AM
  4. Search rows to find specific text and move to a different column ?
    By Udaipur99 in forum Excel - New Users/Basics
    Replies: 19
    Last Post: 03-19-2014, 01:11 PM
  5. Replies: 0
    Last Post: 06-05-2013, 01:18 PM
  6. Replies: 4
    Last Post: 11-13-2012, 02:16 PM
  7. Need to find text in column U and move it 19 columns to the left
    By ed_the_fed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 10:05 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