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?