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 readingHello 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 readingHello 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 readingTwo of my colleagues in the office wanted to know how can they change the creation date of a workbook, and I knew there would be some property of the Workbook, which can be accessed thru VBA. So here is the simple sub to get the new creation date and the message boxes will show […]
Continue reading