Named Ranges

  • Thread starter Thread starter Sunny_Delight
  • Start date Start date
S

Sunny_Delight

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?
 
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))
 
Or one way in VBA

Set DummyRange=Range("Block1").Offset(0,1).Resize(,1)

and

Set DummyRange=Range("Block1").Offset(3,0).Resize(1)
 
Back
Top