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 […]
When writing VBA code that does calculations based on worksheet data and then writes data back to the worksheet you might be waiting longer for a result than needed. Even more so if there are formulas in that worksheet. There are or course more ways to optimize the calculation time. Obviously the alghoritm of your […]
Sometimes you want to retrieve information from the internet for use in an Office Application like Excel. For example, you might want to fetch the latest currency rates or the latest news topics from a website. One way to do that is by using the XMLHTTP object. Generally this is considered to be faster than […]
What are macros? Working with the spreadsheets can be headache at times, especially when the same data are to be entered in the same manner time and again. Hence, Microsoft has come up with the concept of “macros”. The macros are commands that record the actions of the “mouse” clicks as well as the keystrokes. […]
Microsoft Word does not have an automatic feature to count the number of rows in a table; however, you can create a simple macro to return these values Method 1: Use the Information property to return the number of rows Use the Microsoft Visual Basic for Applications Selection.Information property to return the number of rows […]
Fetch Email Addresses – Quick Install & Test Code Open MS Outlook and Select any mail in Inbox or any other Folder Open new Excel Workbook, Alt+F11, Copy Paste the code in this Article In Excel VB Editor go to Tools->References->Add Microsoft Outlook nn.n Object Library Press F5. All Email-Ids (“To”) in the mail you […]
When you are processing operations in Excel, sometimes, you may need to change the negative numbers to the positive numbers or vice versa. Are there any quick tricks you can apply for changing negative numbers to positive? This article will introduce you the following tricks for converting all negative numbers to positive or vice versa easily.
This function will allow you to compare one file to another. Copy code below and paste directly into your VB project. Sub CompareTextFiles() ‘********************************************************** ‘PURPOSE: Check to see if two files are identical ‘File1 and File2 = FullPaths of files to compare ‘will compare complete content of the file, including length of the document (Bit […]