Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for value move to next column code not working
Please assist.
I would like the code to search column a for any instance of total remove it and place in the next column b Dim lastrow As Long Dim strTotal As String Dim Rng As Range Application.ScreenUpdating = False strTotal = "total" With ActiveSheet lastrow = .Range("A1").SpecialCells(xlCellTypeLastCell).Row End With Set Rng = Range("a:a").Find(What:=strTotal, _ After:=Range("a" & Rows.Count), _ LookIn:=xlFormulas, _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False) For I = lastrow To 2 Step -1 If Cells(I, 1).Value = Rng Then Cells(I, 2).Value = Cells(I, 1).Value End If Next I Application.ScreenUpdating = True Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move to the cell on the right, my code not working pls help | Excel Programming | |||
How do I move data based on a conditional column search? | Excel Programming | |||
Search column and move text formula | Excel Discussion (Misc queries) | |||
Column find code not working correctly | Excel Programming | |||
Move a column in one line of code | Excel Programming |