excel using visual basic to read last row?

Question

hi, is there any way i could program a macro where it can automatically read the data inside microsoft excel until the last row and compute them into a line chart? this is because i always need to store in addition data and hope that by just using a button, i will be able to get all the old and new data inside excel to be read and display them into the chart... hope someone will be able to help me thanks

this is the code i using to store the datas into a chart

ActiveSheet.ChartObjects("Chart 12").Activate
ActiveChart.SeriesCollection(1).XValues = "=one!R2C1:R650C1"
ActiveChart.SeriesCollection(1).Values = "=one!R2C3:R650C3"

for this code it only select up to a specific row and if i have more data rows then this, i will have to edit the numbers again, therefore i was wondering if i could edit something on this code so that it would automatically read up till the last row and display all the data into to chart

Answer 1

range("a1").End(xlDown).Address will give you address of the last cell

Answer 2

Macros/vb are used to do repetitive strikes which you may might desire to do manually. look at youtube and seek for excel macro educational. After observing some you would be making your individual very rapidly.