Mohammed,

>and i try via set step on just i get empty excel book with 4 sheets,

When we suggest you use the debugger it's not because it'll change the output of the code. But as you examine the lines of code that execute and the values of the variables and fields you'll be able to find the errors in the code logic. You might want to go to hentzenwerke.com and order a copy of Nancy Folsom's book on Debugging.