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: 18
Default Font.Bold Property slows down macro

Hi everyone,

I wrote a macro which should generate a sheet with comments summary
for current workbook. Everything works great except one thing:
setting Font.Bold=True for a teable header for a first time for
current workbook (second time it works fine) takes 4.75 seconds!!!
Because of this my routine takes 4.8 seconds!!! :(((

1) Can anyone explain why is that?
2) How can I avoid this?

Thanx,
Shahin
 
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
Bold Font Peter Piper Excel Discussion (Misc queries) 2 August 12th 09 09:49 AM
Casing of built-in property Font.Bold RB Smissaert Excel Programming 16 February 4th 08 12:00 AM
BOLD font slows VBA performance in Excel 2003 Juwi_uk Excel Programming 4 November 5th 05 01:42 AM
Unable to set Bold property of the Font Class Mike Lee Excel Programming 2 January 19th 04 06:23 PM


All times are GMT +1. The time now is 11:45 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"