Syntax for getting value of named workbook range
 

I have a workbook I'm referring to as oWB and a named range in the workbook
called PROGRAM. It is not a worksheet range, but a workbook range. For
the life of me, I can't remember how to get the value of the named range
using VBA. Can someone assist?

Thanks,
Barb Reinhardt

Syntax for getting value of named workbook range
 

Assuming the named range refers to a single cell:

owb.Names("PROGRAM").RefersToRange.Value

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

I have a workbook I'm referring to as oWB and a named range in the workbook
called PROGRAM. It is not a worksheet range, but a workbook range. For
the life of me, I can't remember how to get the value of the named range
using VBA. Can someone assist?

Thanks,
Barb Reinhardt