Hi everyone,
I'm new to the forum. Also new to Excel macros and VBA stuff.
Due to a project at work, I need to dig into this for the very first time.

My problem is described as follows:
Input: user specifies a column range which serves as the only argument for the function
For example: E11:E20
The function extracts the number of the rows this column range has, in this case, 10 rows.
Output: The function creates a row array with 10 elements like this {1,2,3,4,5,6,7,8,9,10}

I know the function ROW in Excel can do this in a similar way given that I choose the appropriate cell range.

Sorry for my English. Would highly appreciate any help. Thank you.