Get Named Range From Row Number

Question

My worksheet contains rows that have been assigned named ranges. For example, row 10 of sheet(1) has been named "Kumquats". I want to write a function that returns the name of the named range when the row # is passed to it. So the function call would be:

getRowNamedRange(rowNum as integer) as string

and the function would return the string "Kumquats" if passed the number 10.

Any ideas?

See [HERE](http://stackoverflow.com/questions/3630496/how-do-you-get-a-range-to-return-its-name) it is one line no need for separate function — Scott Craner, Feb 17 '16 at 21:14

score 1 · Accepted Answer · answered Feb 17 '16 at 21:59

1

So according to the reference supplied by Scott something like the following might do:

Public Function getRowNamedRange(rowNum as integer) as string
    getRowNamedRange = Activesheet.rows(rowNum).Name.Name
End Function

answered Feb 17 '16 at 21:59

whytheq

34,466
65
172
267

Get Named Range From Row Number

1 Answers1