If you’ve got something to work on with several excel files. More than 150 excel files generated by a web based application have to be merged into one file and then create a summary from it. A simple way to combine or merge multiple excel files, with macros in Excel.
Ten tips to make coding Excel VBA faster and easier.
When you insert comments to cells, the size of the comment box is the default. If you enter a lot of contents into it, some of the content will not be visible directly. Is it possible to fit the size of the comment box to its content automatically?
This article will tel you how to unprotect an excel spread sheet without having the password
In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.
You can use Visual Basic for Applications to write macros in Excel, or other Microsoft Office apps. Macros are programs that can be used to perform an action repetitively. For example, you can write a macro to get the data from two cells in two distinct columns, add it and then return the output to the user. Now, whenever you want to add the data in two different columns, you can call the macro that you wrote earlier instead of typing a formula in the formula bar each time. You can see why macros are useful- and also why it’s a good idea to learn how to create them.
If you’re not using macros, you’re ignoring one of Excel’s most powerful features. Macros save you time and spare you headaches by automating common, repetitive tasks. And you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel 2013, it’s as simple as recording your keystrokes. Here we’ll […]
The problem: Needing to download hundreds of images instantly We got some 1000+ images on our web portal, and we need to download each of them to local drive so that we can move them to new server all together The Solution: We needed to download the entire list of images and get the file name […]
Sometimes you want to know what the last used row in a worksheet is. There are two ways to interpret this question. You really want to know the last used row in the worksheet is, wether there is a value somewhere in that row or not You want to know the last row that contains a value […]
In Excel you can create a header or footer which includes dynamic data such as the pagenumber or date. However, there is no intrinsic function available to add a subtotal for example. This article shows a method for achieving such. It will calculate the subtotal and grand total for a series of numbers and display […]
A useful feature of Office Applications like Excel and Word is that you can create your own menu’s and menu items. If you are creating an Add-In you will want to create a menu using VBA. By doing so you can simply create the menu when your application is started and you can remove the menu again […]