How to remove a space before the "=" sign and make the formula works properly?

Hello People,

I've created a simple macro to copy-paste the trendline formula from my chart to a cell. After that I replaced the polynoms by specific reference cells which have values.

My issue is that my formulas which came from the trendline do not give me the numerical value result. They work as text, even when I change the format to numerical. A better look showed me that it had a space before the "=" sign formula avoinding me to get the result.

To get the answer I have to press F2 and enter, but as I have several cells like this is hard every single time press F2+enter.

I tried to use this simple macro to solve the issue, but it seems the code does not work when I use a reference cell in the formula, because it keeps giving me a 1004 run time error.

the code is

Please Login or Register  to view this content.

I hope I've made myself clear.

Thanks in advance

Leo

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Take some time to read the Forum Rules, you have six posts in which you have totally ignored the Forum Rules about thread titles, duplicating posts etc.

I'll lock all your posts the next time I see you break the rules

You can use LINEST to get the coefficients directly instead of trying to read them from the equation. If you need help, post a workbook.