Excel property needed

Hi all,

I hope someone here is able to help me.

First a little background on the problem. I am doing an applikation in Access forms, with VBA and in one of my forms I embedded an Excel document. Now this Excel (2000) document is causing me some problems, since I cant get it to show me a dynamic amount of cells in the Access form.
But, I almost think I solved it. This means if I can find this last property to manipulate in VBA. All I know about it is, that its called "Name Box" if you hover over it in Excel.

It gets activated when you select a bunch of cells and says something like 4R x 3C (4 rows times 3 collums).
What I would like to is programmicly set this property to give me YR x 20C (Y is dynamic) and selected from A1 cell.

See the attached picture, to see where to find the "Name Box" - I hope someone is able to help me or know of something that can 'select' the rows and collums.

Thank you, John