Retrieving chart series range data

[Guest]

When you select an embeded scatter chart the x-data and y-data range is
automatically bordered (in the source data table) by Excel. You are able to
alter the range included in the chart by sliding the hot-spot of the border
to resize it. If it is possible I would like to retrieve the range (in A1
format) of the newly resized border. This is to be part of an interactive
chart modifying procedure in VBA. Does anyone have an idea of how to capture
the new range?

 

[Tom Ogilvy]

Sub CleanUpData()
Dim rng as range, rng1 as range
On Error resume Next
Range("C").Specialcells(xlConstants,xlTextValues).EntireRow.Delete
Range("C").SpecialCells(xlFormulas(xlTextValues).EntireRow.Delete
Range("C").SpecialCells(xlBlanks).entirerow.Delete
On Error goto 0
End sub

 

[Tom Ogilvy]

Sorry, this got posted under the wrong thread.

Here is one for you

http://www.j-walk.com/ss/excel/tips/tip83.htm