Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |