Named range in VBA

[Cuperman007]

Hi All,

Is it possible to access a named worksheet range in VBA? What type
would that return?

Thanks,
Mark

 

[Ron Rosenfeld]

Hi All,

Is it possible to access a named worksheet range in VBA?
Yes

What type >would that return?

Range object

Thanks,
Mark

--ron

 

[Dave Peterson]

You could use:

Dim myRng as range
set myrng = thisworkbook.worksheets("somesheet").range("somename")

and it would return a range variable.

You could also go through the Names collection
dim myRng as range
set myrng = thisworkbook.names("somename").referstorange

 

[Cuperman007]

Thanks :-D