Sure, but there is no definition for all the way down the sheet.

for i = 20 to 65536 step 10
cells(i,"E").Resize(,10).FormulaArray = "some formula"
Next

Will fill up the worksheet.

set rng = Activesheet.UsedRange
lastrow = rng.Rows(rng.rows.count).row
for i = 20 to lastRow step 10
cells(i,"E").Resize(,10).FormulaArray = "some formula"
Next

goes through the last used row.

--
Regards,
Tom Ogilvy



jay dean wrote in message
...


Tom-
The Macro ends at E90, but I would like for it to continue all the
way down the sheet. Is it possible?

Thanks!
Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!