I can select a named range like so :

range ("range_01").select

this works. but I want to make the selected range a variable like this:

range_string = "range_01"
range (range_string).select

This gives me error messages "method range of object global failed"


What is the correct syntax for doing this?

Works for me. Did you declare range_string as string?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter Morris" <nospam.ple@se wrote in message
.uk...


I can select a named range like so :

range ("range_01").select

this works. but I want to make the selected range a variable like this:

range_string = "range_01"
range (range_string).select

This gives me error messages "method range of object global failed"


What is the correct syntax for doing this?

"Bob Phillips" wrote in message
...
Works for me. Did you declare range_string as string?


Yes, I did.

You can only select a range if the worksheet that owns the range is active.

And you can only select a worksheet if the workbook that owns the worksheet is
active.

So you can pepper your code with

workbooks("book1.xls").activate
workbooks("book1.xls").worksheets("sheet1").select
workbooks("book1.xls").worksheets("sheet1").range( "range_01").select

or use

application.goto _
workbooks("book1.xls").worksheets("sheet1").range( "range_01"), _
scroll:=true '?

======
And depending on where your code is (is it behind a worksheet?), you could have
the problem because an unqualified range (range("range_01") belongs to the
worksheet that holds the code.

And that might not be where the range really is (and it blows up real good).


Peter Morris wrote:

I can select a named range like so :

range ("range_01").select

this works. but I want to make the selected range a variable like this:

range_string = "range_01"
range (range_string).select

This gives me error messages "method range of object global failed"

What is the correct syntax for doing this?

--

Dave Peterson