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

Dynamically obtaining a range from another range
 

Sharad,

Set NewRange = myRange.SpecialCells(xlCellTypeConstants)

HTH,
Bernie
MS Excel MVP

"Sharad Vyas" wrote in message
...
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

Dynamically obtaining a range from another range
 

Hi Sharad,

Did Bernie's suggestion help you?
If you still have any concern, please feel free to pos there.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.