Function that returns font style
 

Does anyone know a function that returns the font style of a selectio
(or just the color)? I haven't been able to find one anywhere

--
GK8053
-----------------------------------------------------------------------
GK80535's Profile: http://www.excelforum.com/member.php...fo&userid=1546
View this thread: http://www.excelforum.com/showthread.php?threadid=27060

Function that returns font style
 

ActiveCell.Font.colorIndex

ActiveCell.font.Color

ActiveCell.Font.Name

ActiveCell.font.bold (true or false)

and so forth.

--
Regards,
Tom Ogilvy


"GK80535" wrote in message
...

Does anyone know a function that returns the font style of a selection
(or just the color)? I haven't been able to find one anywhere.


--
GK80535
------------------------------------------------------------------------
GK80535's Profile:
http://www.excelforum.com/member.php...o&userid=15461
View this thread: http://www.excelforum.com/showthread...hreadid=270607