Ad Clicks : Ad Views :

Excel formulas and tutorials

Excel formulas and useful tools

img

Run macro on open file event

By
|
In VBA
|
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 and type your macro code inside the Sub Workbook_Open(). I attach a picture for you to see what I […]

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
Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing. Formatting cells to show thousands Right click on the cell you want to format Select Format cells…. From […]
It is main inner container footer text