Thread: refer to a named range in this.workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1926_] Rick Rothstein \(MVP - VB\)[_1926_] is offline
external usenet poster
  
Posts: 1
Default refer to a named range in this.workbook
This is the actual range...

ThisWorkbook.Names("MyRange").RefersToRange

so you can reference any of it properties; for example...

MsgBox ThisWorkbook.Names("MyRange").RefersToRange.Addres s

MsgBox ThisWorkbook.Names("MyRange").RefersToRange.Count

etc.

Rick


"michael.beckinsale" wrote in message
...
Hi All,

How do l refer to a workbook level named range?

I was expecting to use something like this:

ThisWorkbook.Names = "MyRange"

Regards

Michael

Reply With QuoteReply With Quote