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
|