Hello experts,

I hope one of you ca help me out with something (very simple,
probably...).

On one sheet i have a date, and i want to lookup that date in a
different sheet and get the row number.
Ive tried a bunch of diffent matches, but i simply can get it to work..
Any help on this would be really appreciated!

Thanks in Advance

Leen

best-code-so-far-that-ive-been-able-to-think-of :

Sub test()
Dim data_row As Integer
dim date_val as string

date_val= Cells(ActiveCell.Column)
date_row = Application.Match(date_val, Worksheets("data").Range("B:B"),
0)

MsgBox date_row


End Sub