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?

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?

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?