Finding a range

[MarkI]

Hello and Happy New Year

I have an onopen event that references a named range (called "Report" on a
worksheet named "Parameters"). If the Parameters sheet is active when the
workbook is open, the code runs fine, however, if the user saves the file
whilst active on another worksheet, the onopen cannot find the range.

Ideally, I''d like to hide the "Parameters" sheet, but still have the onopen
find the "Report" range regardless of the active sheet at the time of
saving.

Is there a way to do this that is transparent to the user?

Thanks

 

[Bob Phillips]

Does it not work it you address it via the worksheet, e.g.

MsgBox Worksheets("Parameters").Range("Report").Address


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[MarkI]

Does it not work it you address it via the worksheet, e.g.

MsgBox Worksheets("Parameters").Range("Report").Address


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)



Thanks for that, Bob