Excel, Excel Macro, VBA, SQL, R, Python, Tableau Training, Excel Blog, Excel Tips and Tricks

Excel Macro Operators

1 Comment / Excel Macro Training, Excel Training

Mathematical Operators in Excel Macro Operator Action Precedence (1=top; 5=bottom) ^ The power operator 1 * The multiplication operator 2 / The division operator 2 \ The integer division operator – this operator divides two numbers and returns the integer result (eg. 7\4 gives a result of 1) 3 Mod The modulus operator – this […]

Excel Macro Operators Read More »

Data Types in Excel Macro

Excel Macro Training, Excel Training

This Blog Post explain you data types in excel macro. Whenever macro code accept input from user or when you assign value to a variable, you need to define type of data to be store in a variable. for example : dim hindi, eng, math as integer. Here hindi, eng,

Data Types in Excel Macro Read More »