Hi everybody. May be the question is easy but it's making me crazy! I need to calculate numerically an integral from 0 to alpha, and then to optimize alpha as it results as much closes to a number (for example 0,7) as it can be! so I got:

0,7=1+4*(D1(alpha)-1)/alpha

with: D1(alpha)=1/alpha*integral_{0}^{alpha} x/(exp(x)-1)

How could I solve this in vba? I know i can solve it optimizing, but the matter is the integal...

Thank you very much indeed.