I have several spread sheets which contain the following format:
18 columns of data starting on col b.
"b" contains time and "c" contains data.
Then "D" time "E" data, ect...
The problem is the # of rows changes from one file to the next.
Using a macro, I graph the different data required. However, when the file changes and the total # of rows changes, the graphs either come up with lines for time and the data with a point ref for the x axis when the # of rows is less than the original file or i get particial data when the # of rows is more than the original data.
The question is:
Using macro/VB how do I graph the equiv. of the data selected with the following?
Range("B7:C7").Select
Range(Selection, Selection.End(xlDown)).Select
18 columns of data starting on col b.
"b" contains time and "c" contains data.
Then "D" time "E" data, ect...
The problem is the # of rows changes from one file to the next.
Using a macro, I graph the different data required. However, when the file changes and the total # of rows changes, the graphs either come up with lines for time and the data with a point ref for the x axis when the # of rows is less than the original file or i get particial data when the # of rows is more than the original data.
The question is:
Using macro/VB how do I graph the equiv. of the data selected with the following?
Range("B7:C7").Select
Range(Selection, Selection.End(xlDown)).Select