How to find row number of a Defined Name's cell?

I have a spreadsheet that has a cell with a Defined Name, let's call it MyName. How can I set a variable that contains the Row number of the cell called MyName?

I'm relatively new to Excel VBA, though I'm an experienced scripter. I already have a Excel VBA script that does some useful work. I just need to find the row where this Name cell exists, as I can't be sure that rows haven't been added or deleted above this row.

Thanks in advance.

Hi btmtdk. Welcome to the forum! In VBA

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

If it's not a workbook name, but a sheet name you'd need to append the worksheet to the range using either Sheets("sheetname") or the sheet object.

Please Login or Register  to view this content.

Thank you GJ and KV.... Just what I needed! Late a night, my tired brain was searching through the textbooks without success. Then I thought, I bet the ExcelForum folks can help! What a great idea! Thanks so much!

I can't figure out how to flag this post a Solved, but y'all helped me solve my issue!

Hi btmtdk

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solved
- Click Save