Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repetitive block of statements
In my coding, a block of statements get repeated, whenever a control break occurs, while reading the data. In COBOL, such block of statements can be put in a separate para and as soon as the control break occurs, "perform so and so para.." is used. The para is performed and control gets returned to the statement after the abvoe 'perform' statement. I searched for an equivalent in Excel VBA, but I couldn't find any. Any kind suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repetitive block of statements
Hi Murthy Why dont you try the loops http://exceltip.com/st/Using_Loops_i...Excel/628.html OR Goto http://www.vb6.us/tutorials/goto-and...visual-basic-6 If this post helps click Yes --------------- Jacob Skaria "Murthy" wrote: In my coding, a block of statements get repeated, whenever a control break occurs, while reading the data. In COBOL, such block of statements can be put in a separate para and as soon as the control break occurs, "perform so and so para.." is used. The para is performed and control gets returned to the statement after the abvoe 'perform' statement. I searched for an equivalent in Excel VBA, but I couldn't find any. Any kind suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight changes in my data from one block of cells toanother block of cells? | Excel Programming | |||
Repetitive keystroke | Excel Discussion (Misc queries) | |||
repetitive | Excel Discussion (Misc queries) | |||
Convert repetitive IF statements to array loop? | Excel Programming | |||
Repetitive IF THEN Statement | Excel Programming |