excel not switch between sheet

[joemo2003]

I use excel VBA to do a function between everyrow in sheet1 & sheet2, everytime when the function run, it switch between two sheet, so the excel look flash. When the function is runing, how to make it not switch between sheets?
thanks

[SammyB]

I use excel VBA to do a function between everyrow in sheet1 & sheet2, everytime when the function run, it switch between two sheet, so the excel look flash. When the function is runing, how to make it not switch between sheets?
thanks

Application.Scr eenUpdating = False