Number of Rows & Columns in a Named Range
 

Two Part Question:

1. In VBA, how do I determine the number of rows or columns in a named ranged? This will determine the number of times my loop runs.

2. If I'm looking for a specific value in a range (it's first occurrence), how do I determine the row and column number of that value? If that value is not found in the range, will the formula return 0?

P.S. This site has been extremely helpful to me.

Thanks!

Michael