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 😄

alexvilla00's avatar
alexvilla00
Copper Contributor
Oct 06, 2023

LeonPavesic now it's showing 

{=FILTRAR(Eq_Panto[Nombre Desplegable]; Eq_Panto[VAlim]='Configurador Civity LF'!TensionAlim)}

 And not working properly either.

 

Any other ideas?

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

    But that is configuration from the app, right? Is there a way of configuring that when opening my workbook? I need to use this excel using various PCs and I don't want to configure that everytime

     

    Nevermind, that doesn't work anyway 😞

    • 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