All Posts by n.ashutosh

Find the last filled column

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 reading

3 Flip row or column

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 reading

String Operations

I 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
>