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
Bookmarks