Sullivan,

Use something like the following:

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"sullivan" wrote in message
...
Is there any way to turn off screen refresh while running
a program in VB?

Sullivan