Vb ranges - Newbie question

[MarkI]

Hello all

I am defining a range in an application:

Set rnge = range("csv_update")

this works great as long as the code is executed from the worksheet that the
range is on. I would like to hide this sheet and execute the code on a sheet
(in the same workbook) called "Monitor".

How can I get a hold of the range on a hidden worksheet from a button on the
"Monitor" worksheet (or any other worksheet for that matter)?

Many thanks

[Bob Phillips]

maybe try

Set rnge = Worksheets("hidden_sheet_name").range("csv_update")


--
HTH

Bob Phillips

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

"MarkI" <[email protected]> wrote in message
news:[email protected]...
> Hello all
>
> I am defining a range in an application:
>
> Set rnge = range("csv_update")
>
> this works great as long as the code is executed from the worksheet that
the
> range is on. I would like to hide this sheet and execute the code on a
sheet
> (in the same workbook) called "Monitor".
>
> How can I get a hold of the range on a hidden worksheet from a button on
the
> "Monitor" worksheet (or any other worksheet for that matter)?
>
> Many thanks
>
>

[MarkI]

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> maybe try
>
> Set rnge = Worksheets("hidden_sheet_name").range("csv_update")
>
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "MarkI" <[email protected]> wrote in message
> news:[email protected]...
>> Hello all
>>
>> I am defining a range in an application:
>>
>> Set rnge = range("csv_update")
>>
>> this works great as long as the code is executed from the worksheet that
> the
>> range is on. I would like to hide this sheet and execute the code on a
> sheet
>> (in the same workbook) called "Monitor".
>>
>> How can I get a hold of the range on a hidden worksheet from a button on
> the
>> "Monitor" worksheet (or any other worksheet for that matter)?
>>
>> Many thanks
>>
>>
>
>

Thanks for the prompt reply. That was just the ticket :-)

Regards

Mark

[Miguel Zapico]

You can refer the worksheet before the range. In this example, if the sheet
is called "Sheet1" it would be:
Set rnge = Activeworkbook.Worksheets("Sheet1").range("csv_update")

Hope this helps,
Miguel.

"MarkI" wrote:

> Hello all
>
> I am defining a range in an application:
>
> Set rnge = range("csv_update")
>
> this works great as long as the code is executed from the worksheet that the
> range is on. I would like to hide this sheet and execute the code on a sheet
> (in the same workbook) called "Monitor".
>
> How can I get a hold of the range on a hidden worksheet from a button on the
> "Monitor" worksheet (or any other worksheet for that matter)?
>
> Many thanks
>
>
>