First you have to define a SheetList range name (the range of sheet names being the sources of SUMIFS). You can input the name of the sheets in a separate sheet of your excel file. Select all the cells containing this sheet names, then go to the name box field (the upper left field where […]
A very helpful VBA macro that turns any printable excel document into a PDF file. Convert excel to pdf or save excel to pdf Sub savepdf() mo= Month(Date) d = Day(Date) y = Year(Date) h = Hour(Now) m = Minute(Now) s = Second(Now) file= y & mo & d & “-” & h & m […]
The line you should use when you need to set a new background color to a cell is: Sheets(“Sheet1”).Range(“C3”).Interior.Color = RGB(255, 255, 0) The color will be yellow. For other colors please see the color map article.
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 255, where 0 is no color and 255 is the maximum level for […]
To hide an excel sheet so nobody could see it, like the results of a database query when you want just to show a summary based on it, select that sheet and do the following: Making an excel sheet very hidden Right click on the sheet name View Code In the VBA project window that […]
Trying to make charts more expressive is anyone’s objective so that he/she doesn’t have to modify the chart every time a piece of data changes in the source of the graph. Do this by adding variable text boxes inside the chart template. As you can see in the picture, there is an average calculated and […]
Before signing a mortgage loan contract we all must simulate the amounts that we need to repay every month based on the contract conditions. Nobody should accept to sign a loan contract before doing the financial analysis job to understand the full consequences of the contract he is about to enter into. I had to […]
Does the NFC icon appear on the upper screen of your smartphone, or are you reading the specifications of some electronic device and you do not know what is NFC and what does it mean? In few words, the abbreviation comes from Near Field Communication and is a type of RFID technology (Radio Frequency Identification). […]