Macro to Search for a word and put a code on the cell next to it [Solved/Closed]

Question

Macro to Search for a word and put a code on the cell next to it [Solved/Closed]

Report

A.E - Apr 26, 2015 at 06:23 AM
A.E - Apr 28, 2015 at 04:02 AM

Hello,
I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case that raw is dynamic

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
How to search for a word in vim - 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
Search hyperlinks in word - How-To - Word

1 reply

Ask a question

MaxStart · Answer 1 · 2015-04-26T08:12:18-0400

Answer 1 / 1

MaxStart

Posts: 341
Registration date: Tuesday March 3, 2015
Status: Moderator
Last seen: July 3, 2015

64
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

Report

A.E
Apr 28, 2015 at 04:02 AM

thank you for your respond

Macro to Search for a word and put a code on the cell next to it [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!