Turn on the macro recorder, then carry out the steps you want to automate. Recorded
code isn't particularly efficient, but it will at least give you the syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Harsh_Shah wrote:

Thanks Jon.

I could figure out in excel. But I cannot find a way of changing the
number precision of a trendline equation to Scientific using VBA. It is
crucial for my project.

thanks,

harsh