application.screenupdating=false
Application.Calculation = xlCalculateManual
code
application.screenupdating=true
Application.Calculation = xlCalculateautomatic
--
Don Guillett
SalesAid Software

"Scottmk " wrote in message
...
Don,
Actually, I think I have solved all of my problems...thanks to you.
However, you have me puzzled with your last post. I'm not sure what
you mean by turn off screen updating and calculating during macro...how
do I do that?

Thanks again for all of your help,
Scott


---
Message posted from http://www.ExcelForum.com/