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]

maybe try

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


--
HTH

Bob Phillips

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

Thanks for the prompt reply. That was just the ticket

Regards

Mark

 

[Guest]

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.