Can't do much if you don't post your code.

one can hardly program to paragraph 1.

However, it sounds like you could put a formula in the destination sheet and
drag fill it down the column to do what you want.

--
Regards,
Tom Ogilvy

"J.Smith" wrote in message
...
Hi,
I am trying to programmatically iterate through rows, picking the values
of
two cells per row, doing some (simple arithmetic) calculations and writing
output to another sheet. (One write per 32 reads in average.)

I can't figure out what I am doing wrong, because it takes some awful lot
of
time. My input worksheet has 31000 rows and it takes some 40min to step
through them. I am using
Worksheet.Cells(y, x) syntax to retrieve and write values from/to cells.
Can't believe Excel is so lame, hope a faster syntax exists. Even Access
steps through a recordset faster than this. Could not find anything
relevant
in Help. Range transfer to/from VBA array would be great. Using Excel XP
2002 on a 1.5GHz Pent with 512M RAM.

Thanks in advance!