Add

  • Thread starter Thread starter LuisE
  • Start date Start date
Please adjust the range...and set your evaluation code. If you are new to VBE
launch VBE using Alt+F11. Insert Module. and paste the below code....Use Step
Into (function key F8) and see what happens...

Sub LoopthroughRange()
Set rngTemp = Sheets("Sheet1").Range("A1:A10")
For Each rngCell In rngTemp
If rngCell.Text = "<condition>" Then
'your code to evaluate
End If
Next
End Sub
 
Back
Top