Hello All, I was searching for something else at MrExcel.com but found this interesting bit of code. This code will give you the last filled column in a Sheet. Public Sub find_last_column()‘Found at MrExcel.com-solution given by Tom UrtisDim LC%LC = Cells.Find(What:=”*”, After:=[A1], SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).ColumnMsgBox LCEnd Sub
Continue readingTo 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 reading