1 Accessing the Last modified Date in a cell\\ Ok Excel's normal functions don't have this. But its easier to create your own (at little googling and some changes ~~(good to see 4 years of VB weren't wasted)~~:\\ {code} Public Function ModDate() ModDate = "Last updated: " + Format(FileDateTime(ThisWorkbook.FullName), "ddd dd mmm yyyy at HH:nn ") End Function {code} Cut and paste this into the Modules in the VB Editor (Tools > Marcos > Visual Basic Editor). Save this and Select Close and REturn to Excel. Now you have a user defined funtion you can use within your cells just like all the other functions (its even listed in the drop down). Its part of that workbook. 1 Merge two selection of cells into first {code} '************************************************************************** 'Purpose: Merge cells, retaining all data 'Inputs: Selection 'Returns: Merged values in the first cell of rRng '************************************************************************** Public Sub MergeToOneCell() 'J.E. McGimpsey, http://www.mcgimpsey.com/excel/mergedata.html Const sDELIM As String = vbLf Dim rCell As Range Dim sMergeStr As String With Selection For Each rCell In .Cells sMergeStr = sMergeStr & sDELIM & rCell.Text Next rCell Application.DisplayAlerts = False .Merge Across:=False Application.DisplayAlerts = True .Item(1).Value = Mid(sMergeStr, 1 + Len(sDELIM)) End With End Sub {code} 2010-12-09 16:52:01.0 2005-12-19 15:37:10.0