Receive an error in long formula with macro

[yannipr]

Hello

How to fix this macro?

Please Login or Register  to view this content.

Thank You

[Richard Buttrey]

With such a long formula and without seeing it in the context of the workbook that's very difficult to work out.
The "0&" at the start of the formula looks suspect though.

It would have helped if you had also showed what the formula in the worksheet itself looked like. Is that also giving you an error.

Upload the workbook with the formula in the workbook and maybe we can help further.

Incidentally, would you add your location to your profile. It's often useful to know when we frame answers

[AB33]

You need to change all the empty strings in to """". Four times. If you have a none range, that is a string, you need to rub in a string as well.

[yannipr]

Please see the attached file

I want to set this formula to cell B2 with a macro

Thank You

[Richard Buttrey]

I should have spotted it the first time. You need to double up the quotes. i.e.

Please Login or Register  to view this content.

But won't

Please Login or Register  to view this content.

be simpler. There's no doubt a custom format if you don;t actually want the leading zero and - in the cell value and just want to SEE the effect.

[yannipr]

Thank You! Richard Buttrey