R
ranjan rao
Hi all
I just started learning VBA . I have a sheet with multiple tables. I
want charts from some fields of these tables.I recorded a macro by
selecting and copying and manually creating the chart.But the range it
selected was fixed. I need the excel to manually selecting the ranges.
These operations have to be performed repeatedly .
So clearly the problem has following dimensions
1.Determine where a particular range (Table of Data) begins
iteratively for a no. of tables in
the worksheet
2.Relatively reference some cells(say a1-a10 ) for selection of
dataseries
3.Create charts for them
Please help me think in the right direction
Regards
Ranjan Rao
I just started learning VBA . I have a sheet with multiple tables. I
want charts from some fields of these tables.I recorded a macro by
selecting and copying and manually creating the chart.But the range it
selected was fixed. I need the excel to manually selecting the ranges.
These operations have to be performed repeatedly .
So clearly the problem has following dimensions
1.Determine where a particular range (Table of Data) begins
iteratively for a no. of tables in
the worksheet
2.Relatively reference some cells(say a1-a10 ) for selection of
dataseries
3.Create charts for them
Please help me think in the right direction
Regards
Ranjan Rao