Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the values in a named range
Hi,
I want to list, in the inmediate windows, the values of the named ranges in my workbook. I prefer, if possible, not having to specify the worksheet names. I've tried the following code: Sub abc() Dim a For Each n In Names Debug.Print n, n.Name a = n.Value Debug.Print a Next End Sub I get: =sdf!$D$6:$D$8 casa =sdf!$D$6:$D$8 =sdf!$C$12:$D$14 mesa =sdf!$C$12:$D$14 however I would like something like =sdf!$D$6:$D$8 casa 1 2 3 =sdf!$C$12:$D$14 mesa 7 8 9 is this possible? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the values in a named range
Names are children of the workbook. The refersto: data is to identify where
within the workbook the name is used. That is the basics of the Names collection. Your part two illustration is confusing, since the debug print will only provide a predetermined print format. "vsoler" wrote in message ... Hi, I want to list, in the inmediate windows, the values of the named ranges in my workbook. I prefer, if possible, not having to specify the worksheet names. I've tried the following code: Sub abc() Dim a For Each n In Names Debug.Print n, n.Name a = n.Value Debug.Print a Next End Sub I get: =sdf!$D$6:$D$8 casa =sdf!$D$6:$D$8 =sdf!$C$12:$D$14 mesa =sdf!$C$12:$D$14 however I would like something like =sdf!$D$6:$D$8 casa 1 2 3 =sdf!$C$12:$D$14 mesa 7 8 9 is this possible? Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the values in a named range
i use this
Sub name_ranges() ' dumps all named ranges Dim nm As Name For Each nm In ThisWorkbook.Names Debug.Print nm.Name Next End Sub -- Gary Keramidas Excel 2003 "vsoler" wrote in message ... Hi, I want to list, in the inmediate windows, the values of the named ranges in my workbook. I prefer, if possible, not having to specify the worksheet names. I've tried the following code: Sub abc() Dim a For Each n In Names Debug.Print n, n.Name a = n.Value Debug.Print a Next End Sub I get: =sdf!$D$6:$D$8 casa =sdf!$D$6:$D$8 =sdf!$C$12:$D$14 mesa =sdf!$C$12:$D$14 however I would like something like =sdf!$D$6:$D$8 casa 1 2 3 =sdf!$C$12:$D$14 mesa 7 8 9 is this possible? Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the values in a named range
misread the post
-- Gary Keramidas Excel 2003 "Gary Keramidas" wrote in message ... i use this Sub name_ranges() ' dumps all named ranges Dim nm As Name For Each nm In ThisWorkbook.Names Debug.Print nm.Name Next End Sub -- Gary Keramidas Excel 2003 "vsoler" wrote in message ... Hi, I want to list, in the inmediate windows, the values of the named ranges in my workbook. I prefer, if possible, not having to specify the worksheet names. I've tried the following code: Sub abc() Dim a For Each n In Names Debug.Print n, n.Name a = n.Value Debug.Print a Next End Sub I get: =sdf!$D$6:$D$8 casa =sdf!$D$6:$D$8 =sdf!$C$12:$D$14 mesa =sdf!$C$12:$D$14 however I would like something like =sdf!$D$6:$D$8 casa 1 2 3 =sdf!$C$12:$D$14 mesa 7 8 9 is this possible? Thank you |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the values in a named range
On Feb 17, 2:01*am, "JLGWhiz" wrote:
Names are children of the workbook. *The refersto: data is to identify where within the workbook the name is used. *That is the basics of the Names collection. *Your part two illustration is confusing, since the debug print will only provide a predetermined print format. "vsoler" wrote in message ... Hi, I want to list, in the inmediate windows, the values of the named ranges in my workbook. I prefer, if possible, not having to specify the worksheet names. I've tried the following code: Sub abc() Dim a For Each n In Names * *Debug.Print n, n.Name * *a = n.Value * *Debug.Print a Next End Sub I get: =sdf!$D$6:$D$8 * * * * * * *casa =sdf!$D$6:$D$8 =sdf!$C$12:$D$14 * * * * * *mesa =sdf!$C$12:$D$14 however I would like something like =sdf!$D$6:$D$8 * * * * * * *casa 1 2 3 =sdf!$C$12:$D$14 * * * * * *mesa 7 8 9 is this possible? Thank you JLGWhiz, Thank you for your answer, but if I want to put the values of the cells in a Variant, how do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Based on Values in Named Range Q | Excel Worksheet Functions | |||
Sum values in columns based on values in named range | Excel Worksheet Functions | |||
Named range changes values | Excel Discussion (Misc queries) | |||
Using ADO to INSERT Named Range Values into DB | Excel Programming | |||
Iterate through the values in a named range? | Excel Programming |