Hi,
This works for me:
If Cells(b, kolonsayisi).Value <= CInt(UserForm1.TextBox1.Value) Then
Rows(b).EntireRow.Hidden = True
HTH
"barkiny" wrote:
file is simple
i want to sort the data given particular criteria
from start menu i choose top
than i choose greater than
then to the text box i write 4
but the code recognize the 4 as "4" (text)
so hide all the rows
(but i want hide the row if it is less than 4, or show if it is 4
or above)
please hlp i am not going any further!
+-------------------------------------------------------------------+
|Filename: dnm.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3612 |
+-------------------------------------------------------------------+
--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=389184