View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
38N90W 38N90W is offline
external usenet poster
 
Posts: 10
Default Simple Q about font color


"JE McGimpsey" wrote in message
...
What "doesn't work" about your statements?

Either will return 1 of the 56 colorindex values, or
xlColorIndexAutomatic (-4105).

Note if the selection contains more than one cell with different font
colors, Selection.Font.ColorIndex returns Null.



A Ha!

My text in question had different colors, which I hadn't noticed (long story
but a good reason for that).

Seems my problem just a got a bit more complex. Thanks!

-gk-