How to find a cell in a macro..
Closed
bassem
-
May 10, 2011 at 07:16 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 12, 2011 at 05:56 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 12, 2011 at 05:56 AM
Related:
- How to find a cell in a macro..
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Based on the cell values in cells b77 - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
May 12, 2011 at 05:56 AM
May 12, 2011 at 05:56 AM
Use this code, it will helps you
Sub Test()
Dim cell, Rng As Range
Set Rng = Range("A1:K" & Cells(Rows.Count, 1).End(xlUp).Row) ' Set your range
For Each Cell In Rng
If cell.Value = "Tylenol" Then
cell.offset(0,1).formula = "your Formula" ' put your formula
End If
Next Cell
End Sub
