This is category share with you some tip about VBA in Excel. It’s will very useful and funny.
Idea If you have an excel file and there are a lot of overlapping shapes, not beautiful, what will you do. As for me, I will think of some way…
Idea This article I will share about a very useful Add in. That’s caclulator in Ms Word. There may be similar Add in but it will be unique. The idea…
Idea In fact, when making a report you may have trouble with very long data units. If you want to short it into a billion-dollar unit, you have to divide…
Ideas If you have learned about Excel, you will realize that Excel has a huge disadvantage. Specifically Excel 2010 is limited to 1.048.576 rows and 16.384 columns. So to solve…
If you need to split the string separated by delimiters as commas, colon, slash, dash or other delimiter quickly, let’s read the following article. First, I will take a example…
In VBA, there are many interesting functions with its specific functions. In this article, I will share about DIR function and some of its applications in practice. Dir function Returns…
So what is VBA attractive? VBA or Visual Basic Application is a programming language in excel. Understandably, you can write the command line to do what you want in excel.…