Parse data with double spaces

Now, this is very easy to do. But at office spent some good time tackling this problem. The problem was–we had data as a text file from Oracle output, which somehow had double spaces as delimiters, and we got that very late. We had a SAS program, which used to read the file and that […]

Continue reading

True blanks

This about the problem of cells which appear to be blank and which are true blanks. If you check a cell using IsBlank() formula, you’d know if it’s a true blank or not. Even if you copy paste special (values) this =””, there wouldn’t be anything in the cell and length of that cell would […]

Continue reading

Find 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

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
>