View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JonH JonH is offline
external usenet poster
 
Posts: 1
Default Excel "pseudo" ranges

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_6A8E8D88B8 93_.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:$B
Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B8 93_.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?