graphing data

[jdavis9]

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

 

[Mark O'Brien]

Something like this should work:

<pre>
Public Sub test()
Dim oRange As Range
Set oRange = GetUsedRange(Sheets("Sheet1").Range("B7:C7"))

'then just use oRange instead of "Selection"
MsgBox oRange.Address
End Sub

Public Function GetUsedRange(ByVal oTargetRange As Range) As Range
Set GetUsedRange = Range(oTargetRange, oTargetRange.End(xlDown))
End Function</pre>

this also gets rid of the need to use "Selection" in your code which can get really messy.

HTH