Excel VBA - How can I count how many rows there are in a column?

Question

thank you very much for your help!

Answer 1

ActiveSheet.Range _
(ActiveWindow.Selection.Address). _
Rows.Count

Assuming you are refering to a Selected range anyway - Having Selected the Range:
NUMBEROFROWS = ActiveSheet.Range(ActiveWindow.Selection.Address).Rows.Count

Otherwise, you can tell Excel to select for you: (Given you've selected a Start{top} location first)
Range(Selection, Selection.End(xlDown)).Select

Answer 2

count on hands ands toes