Dear Experts

Sheets("Table") has following two columns

sno-----date--
1-----01/01/07
2-----01/01/07
1-----03/01/07
2-----03/01/07
3-----03/01/07
1-----05/01/07
1-----06/01/07

dim mysno as integer, mydate as date
mysno=1
mydate=03/01/07

Now I want to findout Row number inwhich given values are located.
the answer is =4

What VBA codes should I apply? Please help