| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically obtaining a range from another range
Hi all,
I have a user defined range, where i am loading the data to be plotted on the chart. I used max. # of rows and Colmns that can ever be used on the chart, in defining this range. As the data is populated I want to obtain the range from this range, which should contain the noempty cells only. I will know how many rows and columns in user defined range will be there for a given scenario.What is the best way? Here is what I ideally desi MyRage - "A1 - E5" ( I defined this) Loads data which has fills in "A1 - C3" NewRange = MyRange.GetSomhow(A-1-C3") Chart.SourceData = NewRange Any thougths: Thanks -Sharad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Range Dynamically | Excel Discussion (Misc queries) | |||
| Dynamically set a range? | Excel Worksheet Functions | |||
| VSTO2005 - HResult Exception obtaining Range Object | Excel Programming | |||
| How can I dynamically change the range for Range("A1:M500")? | Excel Programming | |||
| Name a range dynamically | Excel Programming | |||
Threaded Mode
