Excel Slowness in 2007 vs 2003

[bsmith81]

Hello - I recently converted to excel 2k7, and am having some slowness issues executing some vba code. I created the macro in 2k7, however it takes probably a minute to run, as opposed to 2k3, which runs almost instantly!? I've pasted the code below:

Please Login or Register  to view this content.

Basically we're taking data from another sheet in the workbook, performing a basic arithmetical calculation, and pasting values into columns in another sheet. *a note, the variable rw is always <200.

I'll post this in the vba section also.

Thjanks!

[royUK]

bsmith81, please read the Forum Rules & use Code Tags when posting code. I;ve added them.

Also, do not post the same question in multiple Forums.

[Rick_Stanich]

I believe it is due to Excel 2007 having 146k rows and Excell 2003 having 64k rows.
Looks like you search every row for a value?

Please Login or Register  to view this content.

[royUK]

That's a very inefficient way to find the next empty cell in any version of Excel, try

Please Login or Register  to view this content.

[bsmith81]

Good thought, but since the data comes in a block starting in A1, that loop only counts up until the data stops, which is never more than 200 rows - so that loop never cycles more than 201 times.

IT seems that when I step through the code, the slowness comes when the values are being moved from one sheet to another. Is there a better way to do this?