| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use "sumif" for cells "0" across multiple ranges? | Excel Discussion (Misc queries) | |||
| "Allow Users To Edit Ranges" Excel-2003 | Setting up and Configuration of Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Can Excel "extract" ranges of numbers listed in the A column? | Excel Discussion (Misc queries) | |||
| Defining Multiple "named" data ranges for Piot Tables in Excel 200 | Excel Discussion (Misc queries) | |||
Threaded Mode
