Vb ranges - Newbie question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkI - 27 Jul 2006 11:51 GMT

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

Reply to this Message

Bob Phillips - 27 Jul 2006 12:01 GMT

maybe try

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

Signature

HTH

Bob Phillips

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

> Hello all
>
[quoted text clipped - 10 lines]
>
> Many thanks

Reply to this Message

MarkI - 27 Jul 2006 12:49 GMT

> maybe try
>
[quoted text clipped - 17 lines]
>>
>> Many thanks

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

Regards

Mark

Reply to this Message

Miguel Zapico - 27 Jul 2006 16:51 GMT

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.

> Hello all
>
[quoted text clipped - 10 lines]
>
> Many thanks

Reply to this Message