Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |