View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Font color in the cells

Range("A1:A10").Font.ColorIndex = 3

--
Jacob


"HuaMin" wrote:

Hi,
How about the way to change the color within VBA?

Bst Rgds,
HuaMin