Active Row Index?

[next]

I'm a total nOob to VBA and i couldn't find an answer to this question in the Help file. How do i find out the row number of actve cell without running a loop command?
example: Column A contains a value in row# 5, i use this to activate it
[VBA]
Sub test()
Range("A:A").End(xlDown).Select
End Sub
[/VBA]
How do i store the row number in a variable? For example in this case var x would be 5.

Thanks for all the help.

[Bob Phillips]

[vba]

myRow= Range("A1").End(xlDown).Row
[/vba]

[next]

Thanks!