I think you might need something like this:
Sub Macro1()
For Each c In Worksheets("Sheet1").Range("A1:B5").Cells
If Abs(c.Value) 110 Then Rows().Select
Next
End Sub
Two problems with the above code though:
1. You have to specify the range
2. You need something inside the () in Rows to tell VBA that it needs
to select the row, whose column contains a value greater than 110.
Sorry, I'm not very good with VBA, hope someone can improve on above.
--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile:
http://www.excelforum.com/member.php...o&userid=18259
View this thread:
http://www.excelforum.com/showthread...hreadid=484781