LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Why isn't this code to change the font colour working?

On Oct 18, 7:52*am, Barb Reinhardt
wrote:
How about (not sure why you have .. instead of . either)

.Cells(MatchLineNum, 22).Font.Color = xlThemeColorLight1



Still not working (with that, or any other colour). It simply doesn't
change the font colour at all.

I've searched this newsgroup's past answers and it appears a lot of
people had issues with it. I've managed a workaround by using a
select, copy, paste method instead of changing the .font.color
property, but why doesn't the .font.color property work? Is it just
2007, or earlier versions as well?

Travis
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change font colour Min Excel Discussion (Misc queries) 9 February 18th 10 01:50 AM
Change font colour Stefi Excel Discussion (Misc queries) 1 March 28th 07 01:54 AM
Change Font Colour in VB Q Sean Excel Programming 5 January 16th 07 02:31 AM
Change font colour [email protected] Excel Discussion (Misc queries) 3 December 23rd 06 07:07 PM
Change font colour for whole row Saleee Excel Worksheet Functions 2 October 10th 06 06:41 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"