title: Column Name, Row Number of a Defined Name
body: <p>I want to know the command to find the Column name of a Defined name and a row number of a defined name in vba. So if B3 is named Candy, i search for Candy and return column B. I google for an hour and couldn't find an answer.</p>
  
  <p>I'm going to use those column name and row number to get data from the intersection and extract it into another worksheet. </p>