Forum Discussion

alexvilla00's avatar
alexvilla00
Copper Contributor
Oct 06, 2023
Solved

VBA Modifying Formulas - Inserting @

Hello, I'm doing an excel with macros and I've encountered an error I can't solve.   When assigning a formula in VBA like this: cb.Formula = "=FILTER(Eq_Panto[Nombre Desplegable], Eq_Panto[VAlim]...
excel
Formulas and Functions
Macros and VBA
  • alexvilla00's avatar
    alexvilla00
    Oct 06, 2023

    Patrick2788 I've tried but for me it's not working, maybe it's because I'm using dynamic tables, I don't know...
    Either way, I've found that using "formula2" instead of "formula" works just fine.

     

     Thanks to all of you 😄

Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 06, 2023
It works for me without issue. It might be worth trying to close Excel completely, open the workbook, and try again.
alexvilla00's avatar
alexvilla00
Copper Contributor
Oct 06, 2023

Patrick2788 I've tried but for me it's not working, maybe it's because I'm using dynamic tables, I don't know...
Either way, I've found that using "formula2" instead of "formula" works just fine.

 

 Thanks to all of you 😄

Resources