It's not clear what your current code looks like, or why an alternative
might require lots of nested for loops, so it's difficult to suggest which
approach is "best".

Best performance or best maintainability ? If the run time is not noticably
different then maintainability should trump.

Tim

<kirkm wrote in message ...
Hi,

I'm reading 11 columns in several hundred rows, processing them and
writing them back to a different sheet.

At the moment each value is assigned to a variant and after finishing
each row, they're sent to a function and and written to the other
sheet.

This lets me use one 'With' clause in the main routine and one
in the function.

I could write each one as it's done though, and wouldn't need to
assign a variant, nor call a function. Instead I'd need a pile of
nested 'With' loops.

Which way is best, please ? Or is it insignificant?

Thanks - Kirk