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