Excel 2007 macro help

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

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
 
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
 
Back
Top