If you need to remove the print view lines, the easiest was is to do it with a macro 🙂 Actually, there should be other ways to do it and there are other ways definitely, but the workaround them (reading …
With this macro we do not actually add something new – it simply does something, which is quite useful if you are working with big documents where you should select the data, based on different values. In the current example, …
VBA – Excel – Activate Sheet Based on Value on Another Sheet Read more »
Changing formulas to values is something really easy in MS Excel – what the majority of people (including me) would do the following – simply record a macro, where you select all cells and paste them as values. The result …
The following formula shows something I did not know for a long time – it counts unique values just like that! Before knowing the existence of this formula, people (including me) had to do a lot of workaround simply to …
Excel – Array Formula for Count of Unique Values Read more »
In the current code, we simply show how to use “OrderBy”, “Select” and “Where” in LINQ. If you want to know more about LINQ, you should refer to here. This time Microsoft has written a really good article about this. …
If you work with VBA macros, you probably have a few lines of code, which you write before you start the actual coding. In this area we include turning off calculations, displaying alerts and screen updating. With other words, this …
Sometimes you simply want to do an action in a file to all sheets, but not to the two important ones, named “Important1” and “Important2”. In this case, you may use a simple for/each loop with a select case option. …
In this article I will simply combine two different subjects – creation of formula, displaying the name of the tab and hiding a specific range per each Excel sheet. Concerning the formula, here it is: =REPLACE(CELL(“filename”,A1),1,FIND(“]”,CELL(“filename”,A1)),””) Concerning the VBA code: …
VBA – Hide specific range per each sheet + formula for tab Read more »
Probably, if you are programming with Excel as much as me, one day you have the following question – all the pictures in Excel are generated by my code and I really do not care to give them names. I …
VBA – How to delete quickly all pictures from Excel? Read more »
This program will calculate square root with two classes. It is really a fascinating program, due to the fact that it uses precalculation in the class SqrtPrecalculated. Thus, if you need plenty of calculations, once the values are precalculated it …
With this article I will simply present you with a solution, combining HTML and VBA, exporting a graph from excel to MS Outlook e-mail. The HTML part is a little complicated and not very flexible, but anyhow – it is …
VBA – send an e-mail from Excel, using MS Outlook and HTML Read more »
With this short article I will briefly explain how to protect your VBA code from viewing from 3rd parties. It is as simple as that: 1. Open the Visual Basic Editor. 2. On Tools select “VBA Project Properties. 3. …
Have you ever had the case to develop a whole solution and at the end someone to tell you the following: “You know, it works well, just insert IFERROR and it is ready to be submitted.” Then you start rebuilding …
VBA – Excel – Adding “iferror” to many cells with one macro Read more »
This is the first book, which would be reviewed on the site vitoshacademy.com. It is probably the best free programming book (as far as I have never heard of another free programming book) for C#. About 1000 of junior Bulgarian …
Book Review – Introduction to Programming with C# – Free Book! Read more »
With the current application you may do the following – enter an expense and select what kind of expense it is. I have predefined some of the expenses, but you may add your own later. What the PHP application actually …
This site checks whether you have deleted your cookies. In order to check whether you have deleted successfully your cookies do the following: 1. Delete your cookies. 2. Refresh this website. If your cookies were deleted, the site will tell …
PHP – Check whether cookies are cleared – Code explained Read more »
On the 14th September 2013 I was participating in a C# competition for advanced by Telerik Academy. After spending 5 hours, trying to solve 5 quite tough C# problems, I have obtained 140 points. With this result I was ranked …
C# – Mutiverse Communication – problem from IT competition/exam Read more »
Hello! This is just a small post, explaining how to reveal a password from any menu at Chrome. Imagine, that you have used the option “Remember password” and due to it you have not even entered it once in the …
In this article I will show how to check data through a VBA code in Excel, which is available in a closed MS Access file. Let’s imagine the following: 1. You have an MS Access database file with some random …
VBA – Reading information from a closed MS Access file Read more »
In this article I will explain two really useful points: What are add-ins? How to get rid of them? (only in case that we need to) If we ask google, we understand that an addin is a component you can add …
MS Excel – Just a little about the add-ins and how to get rid of them Read more »
In this article I explain how to perform a simple task, which is usually given to administrators – extract e-mails from a text. Once, about 4 or 5 years ago I was given such a task and I lost about …
Linear regression is something rather useful for forecasting analysis. If you want to understand more about linear regression, you may go to wikipedia, there you have a wonderful article about it. Long story short, linear regression is an approach, modeling …
In this article with MS Access I will show how to create a good MS Access query, which results in best in class results. Let’s imagine, that we have the following data: In this database, we have four columns – …
SQL – Simple query with MS Access – Best In Class per Class Read more »
In this article I will continue the subject concerning VBA and MS Access. I have thought of a rule of a thumb, presenting only 3 macros per article, thus being sure that the reader does not get bored. Here I …
With this article I am going to present just a few easy Excel Macros, which I have found useful once. The first one is a typical example of loops in VBA and it creates an excel spreadsheet with tabs for …
VBA – Three easy Excel Macros which will make your life easier Read more »
It is quite challenging and quite not interesting to learn SQL if you are a complete beginner – after reading a lot, about installation of servers and programs many people just quit and state that it is not their thing. …
SQL – Access and Wikipedia – quick way to learn the basics Read more »
Hello! In this article I will present a code for the easy export of selected cells into a HTML file. In general, the code functions in the following way: 1. Takes a look at the selected range and performs a …
In this video I perform a check whether a number is an integer or a double. If it is double, it fills out a List<double>(); and if it is integer, it fills out a List<int>(); Once something is entered, which …
I know a lot of people, having problems creating passwords. With the current code I will show you how to create a password using C#. The password consists of at least two capital letters, two small letters, a digit and …
Do you know that VBA can take over all the control over different MS Office applications? This is a simple example how you can open and close a Word application from Excel. In order to do this, you may use …