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

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


© Copyright andrewsexceltips.net All Rights Reserved.