A Custom View is stored information about your worksheet settings, and
you can't refer to it in a formula.

You could name a range, and refer to that in the formula. There are
instructions in Excel's Help, and he

http://www.contextures.com/xlNames01.html

Th10ECn wrote:
I use very large spreadsheets with custom views. However, I can't find a way
to reference the names of the views in formulas, etc. Is there a way that
I'm overlooking or is it impossible to use the names except with the View -
Custom Views dialog box? I would prefer to do it in a worksheet formula but
VBA would be ok.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html