obtaining the format of text in acell

[Sean Farrow]

Hi:
How, through the object model preferably can I obtain the format of text ina
cell?
Any help apreciated.
Sean.

 

[Mike H]

Hi,

Maybe this

GetFormat = ActiveCell.NumberFormat

Mike

 

[Sean Farrow]

Hi Mike, Does this give the format of text, bold, italic etc?
if not how can I do this?
Chers
Sean.

 

[Ron Rosenfeld]

Hi Mike, Does this give the format of text, bold, italic etc?
if not how can I do this?
Chers
Sean.

You'd need to loop through the properties in which you are interested:

For example:

Sub GetFormat()
With Range("a1").Font
Debug.Print .Name
Debug.Print .FontStyle
'etc
End With
End Sub


--ron