Slow macro, slow pc or wrong code?

Hi, i have created a macro to change some values into a cell. i have a dataset with many rows and i would like to divide those rows in packs. my macro asks the pack size, the first and the last row where i want to calculate the pack and then with a loop it will update the value of the "Pack column".


more or less this is the code i used:

Please Login or Register  to view this content.

ColLetter contains the column letter (like "B") where i want to put my pack number.

if i choose a size of 2000 (PackSize=2000) it will put Firstpack for the first 2000 rows after firstrow and then FirstPack+1 for the next 2000 and so on.


I don't understand why it's so slow, say that i have about 10.000 rows is it normal that the macro takes up to 5 minutes to finish the loop? i've created others but i felt this is very slow, any suggestion?

thanks

Massimo

ok thanks, I'll try one of those as soon as i understand how to do it xD

thanks