Help with Excel VB macro...
 

Hi,

I'm working on a macro that will auto-gerate a Pie Chat based upon
list of data. This list of data can vary from being 2 rows to 100
Being utterly useless at Excel VB, is there a simple loop that wil
find the first and last points of the data?

i.e

---A----B
1 data1 4
2 data2 6
3 data3 2
4 data4 5
5 data5 88

So it then figures out that the data range is A1:B5

What do i then need to change in the function below, to look at th
range it has just found in the above search?

ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B5")
PlotBy _
:=xlColumns

Thanks
David Evan


-
David Evan
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message667064.htm