Look up the Cell function in the help files.
May give you what you're looking for.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"John" wrote in message
...
Is there a way to determine how a cell is formatted. i.e. is it formatted
as
1) Text, general, custom 2) Auto row height on or off 3) column width is
3.86
or auto 4) Alignment is General/top 5) Font is arial 8 etc.