Get the format of a cell, eg =getformat(A1)

Function GetFormat(Cell as Range) as String
 GetFormat = cell.NumberFormat
End Function
@

© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.