To flip the given row as shown in this figure, use the following macro Result row You can use the same macro for flipping columns too, code will find if it’s a row or a column. Note: This code was modified on 07/26/07 for error checking, and removal of Option Base Sub flip() Dim Arr […]
Continue readingCheck the following link, it provides limitations of using array formulas in Excel. Description of the limitations for working with arrays in Excel 2000, Excel 2002, and Excel 2003 Note The following are helpful facts to remember about the functions. ? If any cells in an array are empty or contain text, MINVERSE returns the […]
Continue readingThis sub will open the specified file type from the specified directory and sace them as excel files. A file open dialog box will ask the user to select a file from the folder where the original files are kept. Then an output folder name will be asked and this folder should exist otherwise it […]
Continue readingI found this on microsoft’s website. I didn’t know that I can use MID function on the LHS and converting string to ASCII will speed up the process. Cool!! “The following points provide suggestions for ways to enhance the performance of string operations: Minimize concatenation operations when you can. You can use the Mid function […]
Continue readingPMT function has various uses; if you go to Excel help you?ll see its uses. I am using it to calculate monthly payment I have to do pay off credit card debt. If you also want to do that please follow these steps: 1. Type this A1=Card Name, B1=Balance, C1=Years, D1= Interest rate, E1=Monthly Payment, […]
Continue reading