Determining the data type.
Thanks Per for the solution offered.
"Per Jessen" wrote:
Hi
Try this function, just notice, that TargetCell has to be a single cell:
Function CellNumberFormat(ByRef TargetCell As Range)
If TargetCell.Cells.Count 1 Then
CellNumberFormat = "#Range"
Exit Function
End If
f = TargetCell.NumberFormat
CellNumberFormat = f
End Function
Regards,
Per
"satadru" skrev i meddelelsen
...
Dear All,
Without using the "Format -- Cells -- Number" option, is it possible to
determine the data type / format of a particular cell or a range of cells?
I am trying to look for a formula or a piece of code which could possibly
help me out in this.
Many thanks in advance.
|