Curly Braces are generally used in array formulas in Excel. Array formulas are entered by pressing CONTROL+SHIFT+ENTER and Excel automatically inserts curly-braces in formula. Array formulas are useful when one has to get results from multiple set of values into a single cell or range of values.
Array Formula:
For example, Consider Range A1 through A3 has text "No", "Yes" and "None". If we have...
How to remove comments only from filtered cells in Excel
Consider a column which has number one to five. Cell with odd number has a comment "ODD" and even number as "EVEN".
If you have to delete comments only from even number then,
- Filter the even numbers in column (i.e. 2 and 4)
- Then, hit the keystroke (Alt + :) this will highlight...
How to activate other Microsoft application using VBA
in VBA
with
No comments
If you are working on a project that involves interaction with multiple MS Office application, then VBA has a method to invoke other office applications within Excel. For example,
Below code invokes or activates Word application.
Application.ActivateMicrosoftApp (xlMicrosoftWord)
Similarly, replace xlMicrosoftWord to xlMicrosoftMail to activate Outlook. So one can create keyboard...
Static variable in VBA
in VBA
with
No comments
A static variable is a local variable which retain its value even after the execution of procedure. Static variable can be declared by placing static keyword before the declaration.
For example,
static username as string
static counter as integer
In below example static variable "m" retain its value everyime a program is executed
Sub StVar()
Static m As Integer
m = m + 1
MsgBox (m)
End...
The Difference between Cumulative Distribution Function (CDF) and Probability Density Function (PDF)
Cumulative Distribution Function (CDF) vs Probability Distribution Function (PDF)
The Cumulative Distribution Function (CDF) of a random variable 'X' is the probability that the variable value is less than or equal to 'X'. It is the cumulative of all possible values between two defined ranges.On the other hand, Probability Distribution Function (PDF) is the probability of random variable...