Declaring variables in Excel Cells

Declaring variables in Excel Cells

Asked on January 8, 2019 in Excel.
Add Comment


  • 3 Answer(s)

    Try this best solution : 

          We can assigning name for a cells, by clicking the Name Box, for example formula bar says “A1” for example. And entering a name, like as, “myvar”. Further can use that name alternately of the cell resource.

    Use this code

    = myvar*25
    
    Answered on January 8, 2019.
    Add Comment

    Use this alternative solution : 

             The lingo in excel is unlike, so does not “declare variables”, and “name” cells or arrays.

    Answered on January 8, 2019.
    Add Comment

    By using hidden cells as a variables. for example in case want to hide Column C, set C1 to

    =20
    

    and apply it as

    =c1*20

    Instead of you can write VBA Macros that may be set and read a global variable.

    Answered on January 8, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.