View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shahin Musayev Shahin Musayev is offline
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