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

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