In VBA I'm able to work with a single cell named range. E.g. Set Jr = Range ("Year").Value.

Also other options are working fine, like Range("Year").Address shows $L$3.

However a named range refering to multiple cells is not working for me. Eg. tbl_Test has the Address $R$25:$T$33.

Set tTest = ActiveWorkbook.Worksheets("Basis").Range("tbl_Test") result in: Application defined error

Also sAddress = ActiveWorkbook.Worksheets("Basis").Range("tbl_Test").Address results in: Application defined error

Any help on how to refer to a multiple cells Named Range would be highly appreciated.

Kind regards, Rob