| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
I am getting used to using named ranges but I am finding that in large tables
I occasionally want to refer to one column or one row of the table. Is there any way this can be done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named Ranges
Assuming a range named "Block1", this
formula will return the sum of the cells in column 2 of Block1: =SUM(INDEX(Block1,0,2)) and this one the sum of the cells in row 4. =SUM(INDEX(Block1,4,0)) -- Best Regards Leo Heuser Followup to newsgroup only please. "Sunny_Delight" skrev i en meddelelse .uk... I am getting used to using named ranges but I am finding that in large tables I occasionally want to refer to one column or one row of the table. Is there any way this can be done? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named Ranges
Or one way in VBA
Set DummyRange=Range("Block1").Offset(0,1).Resize(,1) and Set DummyRange=Range("Block1").Offset(3,0).Resize(1) -- Best Regards Leo Heuser Followup to newsgroup only please. "Sunny_Delight" skrev i en meddelelse .uk... I am getting used to using named ranges but I am finding that in large tables I occasionally want to refer to one column or one row of the table. Is there any way this can be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges | Excel Worksheet Functions | |||
| Named Ranges | Excel Worksheet Functions | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| Named Ranges and VBA Add-ins | Excel Programming | |||
| Named Ranges and VBA Add-ins | Excel Programming | |||
Hybrid Mode
