Creating an automatic range updater

I have a project im working on that ive made with a pulldown menu on the chart which has 6 options. Each option auto-populates the graph with its corrosponding data. The problem is the data sheet i will be using will have a different number of points each time I import them. How can i setup a range that will update itsself upon import. So far i have used a cell on the Datasheet with the following equation

=COUNTIF(A:A,">=0")+2

@location I3

So i tried .Range("A1:A(Cells(3,9))") but it doesnt like that at all... any ideas would be great


Tony

you can use the offset function as the makeup for the list parameter of a data validation dropdown menu. if you base this on the count statement that you have you should be able to tell it to start at a certain cell then stop at that position but offset the count of rows

any probs attach a raw data file and ill have a nosey