What is meant by DIM

     

     

  • DIM is a statement which is used to Declare VARIABLES
  •  

  • DIM represents to DIMENSION
  •  

     

  • DIM followed by VARIABLE NAME
  •  

  • AS is a key word utilized to mention Data Type for VARIABLE NAME
  •  

  • DATA TYPE must be followed by AS
  •  

  • Variable Name and Data Type must be mentioned after DIM
  •  

    What is meant by VARIABLE

     

  • A variable is used to store the data temporarly and used based on our requirement
  •  

     

  • Variable name should not matchd with excel KEY WORD.,
  • Loop,if,do,date,next,...

     

     

  • Every variable must be named and that name should be UNIQUE
  •  

  • Variable name should start with ALPHABHET
  •  

  • Variable name should not start with NUMBER
  •  

  • Variable name should not exceed 255 characters
  •  

  • Space is not allowed in between the vairable name., but we combine the words with underscore _
  •  

  • Letters, Numbers or underscores as part of Variable Name
  •  

  • Special characters should not part of variable name i.e, (% ^ & * ( ) + $ / < > ? - =! @ # \ | ` ~ (.) [ ] { } ; ' : " , . ).
  •  

    Variable type declaration