Ad Clicks : Ad Views :

Excel formulas and tutorials

Excel formulas and useful tools

RGB color map

By
|
On February 14, 2018

Using colors in excel and VBA is very simple. The most used function is RGB(x, y, z). Where x is the variable for red color, y is for green and z is for blue. All variables can have values from 0 to 2

img

Excel macro for loop

By
|
In Excel Macro , VBA
|
On October 14, 2016
This is a tutorial for beginners to learn excel macro for loop. Loop sequences may be achieved by using a FOR block or a WHILE. Macro for loop using FOR A FOR block looks like this: For i = 1 To 100     Range(“A” & i) = “Number” & i Next i Where i is […]

Run macro on open file event

By
|
On October 14, 2016

In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel

1 2 5
It is main inner container footer text