Forum Discussion

valentingiaufer's avatar
valentingiaufer
Copper Contributor
Oct 18, 2023
Solved

Automatically added @ in formulas

Hello  I want to add a formula in my cell:     =SheetNameFunc()&""-""&ANNEE(AUJOURDHUI())&""-""&MOIS(AUJOURDHUI())     But each time the formula is added in the cell, excel automatically add...
developer
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Oct 19, 2023

    valentingiaufer 

    The Formula property expects a formula in English. You could use

     

    ThisWorkbook.Sheets(SheetName).Range("H1").Formula = "=TEXTJOIN(""-"",,""Export"",SheetNameFunc(),YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

     

    To specify it in your local language, use FormulaLocal:

     

    ThisWorkbook.Sheets(SheetName).Range("H1").FormulaLocal = "=JOINDRE.TEXTE(""-"";;""Export"";SheetNameFunc();ANNEE(AUJOURDHUI());MOIS(AUJOURDHUI());JOUR(AUJOURDHUI()))

Tina_Gao's avatar
Tina_Gao
Copper Contributor
Oct 23, 2023

I have the same problem, each time I re-opened this file, '@' is automatically added to the below formulas, would you please suggest a solution? Thanks a lot! HansVogelaar 

 

=TEXTJOIN(" ",TRUE," WRITE-VARS",IF(@H10:H502<>"",G10:G502,""))

 

=IFERROR(@INDEX('Aspen Data In'!D:D,SMALL(IF(@'Aspen Data In'!D$3:D$800<>"",@ROW($3:$800)),ROW('Aspen Data In'!D1))),"")

 

HansVogelaar's avatar
HansVogelaar
MVP
Oct 24, 2023

Tina_Gao 

Sorry, no idea. I cannot reproduce the problem.

Resources