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? |
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? |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com