Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice on With-End With
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice on With-End With
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice on With-End With
Perhaps you should post your code for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice on With-End With
On Sat, 16 May 2009 16:02:26 +1200, kirkm wrote:
Thanks guys.... I couldn't impose my code on anyone though! As well as bad it's extremely complex! I'll leave it as is... it's fast enough and does what's required :) Cheers - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice Please? | Excel Programming | |||
Help, need advice | Excel Programming | |||
need advice | Excel Programming | |||
RTD Advice | Excel Programming | |||
please advice | Excel Programming |