Creating a macro that gets data from text file and charts it.

OK
Need to create a macro that imports data from a text file one or two columns. Place the data starting at "A1" and down. Data could be any length of rows. My macro does this "Range(Selection, Selection.End(xlDown)).Select. The problem is three lines down..." ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$A$15")". How do I pass the Range Selection to the ActiveChart.SetSourceData Source to get all rows starting from "A1" to the bottom of data? It could be column "B1" included also. Each sheet in the Excel file might have a different text file to import.

Any help would be greatly appreciated!

jon124

thank you that's it.