Ad Clicks : Ad Views :

Excel formulas and tutorials

Excel formulas and useful tools

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

Excel VBA Macro

By
|
On October 12, 2016

This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual acti

img
Large tables in Excel look much more better and are easier to read when we choose to alternate row color. Each other row gets a background color, so it’s easier to read the values in the extreme right in association with the labels at the extreme left of the table. 3 ways of alternating rows […]
img
In order to find and remove duplicates or just highlight them in an complex and messy Excel spreadsheet be prepared to work hard or just smart and elegant. Too many times we end up with an extralarge Excel file that contains some very complex information and a lot of duplicates that we need to find […]
This div height required for the sticky sidebar