I've made a macro but it isn't working.
Could somebody help me.
Dim k As String
Dim l As Variant
k = ""
k = Application.InputBox("Van welke persoon wilt u een overzicht", "overzicht", Type:=2)
Loop While k = ""
Selection.Find(What:=k, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate 'with this line i find a name in a colum'
'Now i want to know the row number, for example it is 12'
l = row() 'i think this is wrong, but i don't know what!'
'because i want to use that number in an other sheet'
In VBA, getting the row is a little different. You must have some sort of worksheet object to return the row from. If it's not valid then it won't work. In the code you posted, Activecell.Row would have sufficed for the row number, but you don't need all that selecting and activating going on.