| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with events
Cool that works
thanks "Tom Ogilvy" wrote: No, Font isn't a child of Interior. You would have to set it up slightly differently With Rows([ThisRow]) .Font.ColorIndex = 1 With .Interior .ColorIndex = 46 .Pattern = xlSolid End With End With if you wanted to still use With. -- Regards, Tom Ogilvy "A1pro" wrote in message ... Thanks that works great in order to change the font colour of the whole row I've had to add With Rows([ThisRow]).Interior .ColorIndex = 46 .Pattern = xlSolid End With Rows([ThisRow]).Font.ColorIndex = 1 ' ensures that font is black as adding .font.colorindex = 1 or .font.color = 1 to the With statement would not work. any ideas why? The way I do it works, but it just doesn't seem too elegant Thanks for your time anyway |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| do events? background events | Excel Programming | |||
| events? | Excel Discussion (Misc queries) | |||
| how do I log events | Excel Programming | |||
| Events | Excel Programming | |||
| events | Excel Programming | |||
Threaded Mode
