Naming Range - can't find an easy solution

[Sal_Gxer]

I've looked through the "Search" option but can't find my answer.
I am creating a column chart where the source data number of rows changes monthly. How can I write it so it chooses the necessary data (only 2 columns).

TIA.

Sal

 

[Aladin Akyurek]

I've looked through the "Search" option but can't find my answer.
I am creating a column chart where the source data number of rows changes monthly. How can I write it so it chooses the necessary data (only 2 columns).

TIA.

Sal

Let A:B house on Sheet1 the data with headers in A2:B2 where column B is numeric.

Define...

Name: Drange

Refers to:

=Sheet1!$A$2:INDEX(Sheet1!$B$2:$B$65536,MATCH(9.99999999999999E+307,Sheet1!$B$2:$B$65536))

 

[Sal_Gxer]

I'm still a novice at this VBA. I tried lookin garound for hoe to define and all that but still a little confused - could you give me the whole code?
I'll learn this soon, thank you

Sal