Hai,
I am devolping an excel sheet which takes the data from
the database,for that data i have to draw a chart i con't
select the area directly so i wan't to draw it by using
recordset plz help me..

Thank you

With Regards
Rajesh.A

Have you considered turning on the macro recorder (Tools | Macro >
Record new macro...), doing whatever it is you want to do, and turning
off the recorder. Depending on exactly what it is you are trying to
do, XL may give you the necessary starter code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <1450301c41bd2$19d57c40$(E-Mail Removed)>,
(E-Mail Removed) says...
> Hai,
> I am devolping an excel sheet which takes the data from
> the database,for that data i have to draw a chart i con't
> select the area directly so i wan't to draw it by using
> recordset plz help me..
>
> Thank you
>
> With Regards
> Rajesh.A
>

Rajesh -

The easiest way to accomplish this may be to put the data from the
recordset into the worksheet, and plot this range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rajesh.Arra wrote:

> Hai,
> I am devolping an excel sheet which takes the data from
> the database,for that data i have to draw a chart i con't
> select the area directly so i wan't to draw it by using
> recordset plz help me..
>
> Thank you
>
> With Regards
> Rajesh.A