Updating a datasheet without all the blinking
 

Hi there,

Using Updating a wroksheet in Excel. Is there a way to freeze the
worksheet so that all the updates are only presented once they have
been completed.

Thanks,

Aine.

Updating a datasheet without all the blinking
 

Application.ScreenUpdating = False
do your thing
Application.ScreenUpdating = True

--
Gary''s Student - gsnu200731


" wrote:

Hi there,

Using Updating a wroksheet in Excel. Is there a way to freeze the
worksheet so that all the updates are only presented once they have
been completed.

Thanks,

Aine.