obtaining the format of text in acell
 

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

obtaining the format of text in acell
 

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.

obtaining the format of text in acell
 

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.

obtaining the format of text in acell
 

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