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

Hi,

Maybe this

GetFormat = ActiveCell.NumberFormat

Mike

"Sean Farrow" wrote:

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

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

Maybe this

GetFormat = ActiveCell.NumberFormat

Mike

"Sean Farrow" wrote:

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

On Tue, 9 Dec 2008 19:40:46 -0000, "Sean Farrow"
wrote:

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