Repetitive block of statements

[Murthy]

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?

 

[Jacob Skaria]

Hi Murthy

Why dont you try the loops
http://exceltip.com/st/Using_Loops_in_VBA_in_Microsoft_Excel/628.html

OR Goto
http://www.vb6.us/tutorials/goto-and-gosub-visual-basic-6

If this post helps click Yes