Hi Karl,

Check that you have

Application.calculation=xlManual

.... your code

Application.calculation=xlautomatic


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Karl Burrows" wrote in message
.. .
Hi!

I created several worksheets that contained huge lists, so I created a
dynamic named range. Now that the name has been inserted in my array
formulas, my Macro runs very slowly. The Macro unprotects one of my
sheets,
sorts the data in a table, hides the blank rows and the protects the sheet
again. There are no related named range formulas in that worksheet, so
I'm
not sure why it would be affected. The Macro ran quickly when I had a
defined range of data.

Would giving a named range like 'Date' and having text in my workbook with
'Date' create conflicts? Could this affect my Macros?

I'll be more than happy to send the formulas and Macro if you want to look
at them further.

Thanks!