Excel "pseudo" ranges

  • Thread starter Thread starter JonH
  • Start date Start date
J

JonH

I used a tool called "Name Manager" to summarize all of the ranges in a
spreadsheet. It surfaced a large number of ranges that end with the
following:

"_.wvu.PrintArea", "_.wvu.PrintTitles", "_.wvu.Cols", "_.wvu.Rows"

below are some examples:

Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu.PrintArea =Balance_Sheet!$A$1:$P$141
Bud Exp
Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu.PrintTitles ='Bud Exp
Study-ITLF'!$A:$
Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu.Cols =Balance_Sheet!$S:$AG
Bud Exp Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu.Rows ='Bud
Exp Study-ITLF'!$50:$71

Anyone know what generates ranges like this?
 
Bob Phillips has posted this list of (partial) names that excel uses:

*_FilterDatabase
*Print_Area
*Print_Titles
*wvu.*
*wrn.*
*!Criteria
*xlfn.*

(* is a wildcard that represents any string.)

Some of those are created by web queries, Advanced Filter, conversion from
xl2007 to earlier versions, maybe solver(???).

But that's not too definitive. I think I've seen some of those names that are
attributed to solver in workbooks that have never used solver.

All I know is that I'm careful to avoid deleting those names when I'm cleaning
names.
 
Back
Top