Macro to Search for a word and put a code on the cell next to it
Solved/Closed
        Related:         
- Macro to Search for a word and put a code on the cell next to it
 - How to search for a specific word on a webpage - Guide
 - How to search for a word in a pdf - Guide
 - Ms word mod apk for pc - Download - Word processors
 - How to search nearby friends on facebook - Guide
 - How to search a youtube channel - Guide
 
1 response
                
        
                    MaxStart
    
        
                    Posts
            
                
            338
                
                            Registration date
            Tuesday March  3, 2015
                            Status
            Moderator
                            Last seen
            July  3, 2015
            
            
                    69
    
    
                    
Apr 26, 2015 at 08:12 AM
    Apr 26, 2015 at 08:12 AM
Sub go()
Dim i As Integer, Cell As Range, Cell2 As Range
i = 1
'This will Search Sheet1 Column1
'and set the value to cell next
Do Until ThisWorkbook.Sheets(1).Cells(i, 1).Value = ""
    Set Cell = ThisWorkbook.Sheets(1).Cells(i, 1)
    Set Cell2 = ThisWorkbook.Sheets(1).Cells(i, 2)
    If Cell.Value = "TOTAL LINE" Then
        Cell2.Value = "a"
    End If
i = i + 1
Loop
End Sub
                
                
        
    
    
    
    
Apr 28, 2015 at 04:02 AM