How can I put this code into a loop..

[purpleozzie]

Hiya,

I've designed a spreadsheet withabout 15 editable fields. It has a 'save' button which runs a macro that moves everything that's been edited into another sheet.. One row per customer..

Please Login or Register  to view this content.

My question is, is there a better way of doing it... I'm thinking a loop but the cell reference is different on each line..


Cheers,

[Andy Pope]

Your right that a loop is not possible as the addresses of the righthand side are not in a logical sequence.
But you can loop using the For Each loop.

Please Login or Register  to view this content.

Can you please edit your post to fix the code tags.

[purpleozzie]

Thanks Andy.. Worked perfectly