Code Help

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

Can you please help me with some code:

I have 3000 +/- rows in my worksheet, with only one
column. In any row, if the word "INC" is present in
a sentence, then in column two I want the word "CORP" to
appear. Thanks in advance.

DaveB
 
try this simple macro

Sub findinc()
Cells(Columns(1).Find("INC").Row, "b") = "CORP"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Help 4
Code Help 1
Simple Code Help 1
Wildcards 5
PowerPoint Powerpoint Slow Animations 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Formula to search for a word and put that entire row in a list 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top