LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default .Font.ColorIndex Delay Question

I have run into a problem when I code using .Font property. I am using
Excel 2003.

The code can be anything that calls up the font property, like
Cells(1,1).Font.ColorIndex = 3

When Excel runs it the first time, it takes quite a few seconds to
accomplish. However, after that,it runs at speed.

This also happens if I format a cell's font the first time I access the
font property in Excel wihtout using code.

Is there a way to get around this delay? Or is it my copy of Excel?

As I said, once Excel opens up the font property, it calls up the font
in a normal speed after. No more delay.

I appreciate any help on this issue.

Thank you.
 
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
Font ColorIndex, Ws Change Event Neal Zimm Excel Programming 2 August 25th 07 08:04 AM
Can't set font.colorindex from VBA Mike Jamesson Excel Programming 4 August 19th 05 02:20 PM
VBA Error setting Font.ColorIndex Steve Barnett Excel Programming 4 June 24th 05 11:00 AM
If Font.ColorIndex = 5 then . . . jeremy nickels Excel Programming 2 March 4th 05 11:29 AM
Font and Fill ColorIndex Frank[_19_] Excel Programming 3 October 31st 03 01:52 PM


All times are GMT +1. The time now is 08:12 AM.

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"