thank you all for the help,
i think its true the most easy way is to do it with the autofilter,
but the goal is to make it work without it!!!
i have a thought of multiple if and row transfer....
and then with a macro to hide the error formulas....
but i have no other options..... if i want something more special i think
that the access is the way? or just take the autofilter..... any other
opinion?
thanks all of you!

"anar_baku" wrote:


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