View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
todtown todtown is offline
external usenet poster
 
Posts: 35
Default Find a Named Range programatically using VBA in Excel

Here's an easy one for somebody. I have several named ranges on a
worksheet. Each named range represents a cell where I want to put the
results of a query. For example, if I have a range named "Investments"
somewhere on the sheet, and that range represents cell C25. What code
could I use to return the range address for the given named range?
Sounds easy just typing it, but I guess I just don't have the book
learnin' for such things. <g

tod