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 word on a page chromebook - How-To - Google Chrome
- Vim how to search for a word - How-To - Linux
- Excel/VBA - A macro change page in a Word document - How-To - Excel
- How To Search for a Word in a PDF - How-To - PDF
- Macro to search for a value in excel - How-To - Excel
1 reply
MaxStart
- Posts
- 341
- Registration date
- Tuesday March 3, 2015
- Status
- Moderator
- Last seen
- July 3, 2015
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
Report
A.E
thank you for your respond
