Excel 2007 macro help

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
 
O

OssieMac

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
 
Top