Unable to set FormulaArray property of the Range class VBA

Hi,

I have recorded a macro that formats my report automatically. However, I encounter an error when running the macro "Unable to set FormulaArray property of the Range class". Here is the code with error that i encounter with

Please Login or Register  to view this content.

. I don't know how to write the code for this macro to work.

I attached my report for your reference. I hope you can help me on this.

Can anyone help me with my code please. thansk

Hi,

Yes I did. But when i ran the code, I encountered the error as attached.

It seems the problem with the array formula is the limitation of 255 characters. The work around I read to split the formula, but I can't figure it out how to do it. I hope someone helps me on this.

Up. really need help on this. thanks

Originally Posted by JosephP

you can shorten the names of your tables a lot to t_1, t_2 and so on then use this

Please Login or Register  to view this content.

Thanks! This works perfectly!

Hello,

Thank you for providing the code. It works perfectly.

However, I need to rewrite the formula I wrote because it was flawed. I tried copying the code you provided me but I couldn't replicate your code. Here is the formula that I wrote:

Please Login or Register  to view this content.

I hope you can help me again to translate the formula into VBA code similar to what you did in the previous formula.
Thank you in advance for your help.

Originally Posted by bambino86

Hello,

Thank you for providing the code. It works perfectly.

However, I need to rewrite the formula I wrote because it was flawed. I tried copying the code you provided me but I couldn't replicate your code. Here is the formula that I wrote:

Please Login or Register  to view this content.

I hope you can help me again to translate the formula into VBA code similar to what you did in the previous formula.
Thank you in advance for your help.

Up! Need hep on the code