Thanks hdb. It turns out that actually doing that for loop with repeat formula after the DBI while loop was causing the problem. Doing what you suggested above but putting before the writing from DBI block made it work.Thanks a bunch!!