Excel 2007 : Subscript out of range

[ususgoreng]

help me, i can't fix this problem,
i want to arrange some number (small array) into one big array
there's column and row number located above and beside the small array [km], that is location of number from small array at big array.
i tried with smaller one (asdwx.xlsm) 10x10, it works, but when i try (help.xlsm), 204x204 it doesn't work.
it said error '9' subscript out of range.
idk why.
thanks

[ususgoreng]

help me

[tigeravatar]

ususgoreng,

Alright, first of all, your variable names should be more than just a or b. They should accurately describe the information being assigned to them. It would also be a good idea to dim your variables to the appropriate type so that they don't take as much memory and are easier to reference. I updated your code, and it now runs successfully and faster. (Although I didn't optimize it)

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[ususgoreng]

wow, that's work.
thank you very much man.



admin : sorry i double post this thread..