Excel 2007 macro help
I've recorded a macro that opens a csv file and then applies quite a lot of
formatting, including setting page titles, freezing panes, autofitting colums, and more. When I run the macro it works ok, but it takes quite a bit of time to run. Is there anyway of speeding this up, or is this to be expected? Thanks for any help -- Michelle |
Excel 2007 macro help
Hi Michelle,
You could try inserting the following line of code at the start of your code Application.ScreenUpdating = False and then insert the following code at the end of your code Application.ScreenUpdating = True -- Regards, OssieMac "Michelle" wrote: I've recorded a macro that opens a csv file and then applies quite a lot of formatting, including setting page titles, freezing panes, autofitting colums, and more. When I run the macro it works ok, but it takes quite a bit of time to run. Is there anyway of speeding this up, or is this to be expected? Thanks for any help -- Michelle |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com