Introduction: We use programming language to build applications that we use in our work and domestic lives. This is true for almost every computer application that we use. There are numerous languages out there, that are at the disposal of the programmers that use them for various purposes. The language that is used to add more functionality to MS Office, or is used as a … [Read more...]
7 Things CPA Should know about VBA Macros
VBA stands for visual basic for application. It is the default programming language for MS Office. If you want to program MS Excel you should know how to work with VBA Macros. VBA is at the same time is fun and a source of improving productivity. Actually it provides an opportunity to do things what canot be done in usual way or to have features that are not available by … [Read more...]
Delete Every Other Row in Excel
Sometimes you will copy and paste data into a worksheet from another file, a web page, or some other source that isn't formatted the way you want it. Often times there is extra irrelevant data like row numbers or other miscellaneous information that gets added in when you paste the data. If the unneeded data is on it's own row, you can delete every other row easily with the … [Read more...]
Create a User Defined Function
Excel allows you to create your own "User Defined Functions" (UDF) that can be used the same way as any other built-in function in Excel (i.e. IF, SUM, VLOOKUP, etc.). With a little knowledge of VBA code, you can create your own function to do pretty much whatever you want. To illustrate how to create a UDF, we'll create a function that calculates fuel consumption in miles … [Read more...]