How to find a cell in a macro..
Closed
bassem
-
10 May 2011 à 07:16
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 12 May 2011 à 05:56
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 12 May 2011 à 05:56
Related:
- How to find a cell in a macro..
- How to delete a cell in word - Guide
- How to run a macro in excel - Guide
- Run macro on opening: worksheet, workbook - Guide
- How to type multiple lines in a cell in excel - Guide
- How to copy macro from one workbook to another - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday 7 February 2011
Status
Contributor
Last seen
30 September 2013
120
12 May 2011 à 05:56
12 May 2011 à 05:56
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
