<div>
Sorry I messed up a bit... &nbsp;in Ln6 can we chg that to be an If And? &nbsp;I need the contents of column C and Column A to be blank. &nbsp;Is that a hard edit?
</div>


Sorry I messed up a bit...  in Ln6 can we chg that to be an If And?  I need the contents of column C and Column A to be blank.  Is that a hard edit?

<div>
I should say this different... &nbsp;sometimes there is blank in column C, but not in column A, but I am checking the cell contents of column C. &nbsp;Hope this makes sense... &nbsp;The dataset number of rows is determined by the number of rows in column A
</div>


I should say this different...  sometimes there is blank in column C, but not in column A, but I am checking the cell contents of column C.  Hope this makes sense...  The dataset number of rows is determined by the number of rows in column A

<div>
Figured it out... &nbsp;chg'd the C1 in Ln5 to A1 and it handled the whole dataset &nbsp;works great. &nbsp;Thanks!!
</div>


Figured it out...  chg'd the C1 in Ln5 to A1 and it handled the whole dataset  works great.  Thanks!!

<div>
<div class="content wysiwyg-content">
Using VBA I was wondering if I could loop thru the contents of each cell in Column C (until it reaches a blank cell) looking for a value like DEPOSIT. &nbsp;If the word DEPOSIT shows anywhere in the contents of the cell in column C, change the cells (of that row) A thru F green and put the value: &quot;My pay check&quot; in column F.<br />
<br />
The odd part is that when searching column C, we are not searching for exact contains of the cell. &nbsp;It is part of the contents. &nbsp;Column C could be &nbsp;&quot;DEPOSIT 12-29-2016&quot; but because it has the word DEPOSIT it would be true.<br />
<br />
Looking for some assistance. &nbsp;Thanks.
</div>
</div>


Using VBA I was wondering if I could loop thru the contents of each cell in Column C (until it reaches a blank cell) looking for a value like DEPOSIT.  If the word DEPOSIT shows anywhere in the contents of the cell in column C, change the cells (of that row) A thru F green and put the value: "My pay check" in column F.

The odd part is that when searching column C, we are not searching for exact contains of the cell.  It is part of the contents.  Column C could be  "DEPOSIT 12-29-2016" but because it has the word DEPOSIT it would be true.

Looking for some assistance.  Thanks.

Search for a value in Column?

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.