vba - internediate step test

[pingpong777]

hello. i have a macro that is approximately:
___

do

paste values_1

for n = 1 to 6

calculate

paste values_2
paste values_3

next n

___


i would like to put a test between "calculate" and "paste values_2", so that:

___

if the value of a certain cell = 0 Then

stop going through the "for n = 1 to 6" routine and go to the next step after "next n" Else

continue
___

apologies for my sloppy syntax here within my question. can somebody help me with the command to get the routine to skip past the remaining "n" repetitions? do i even need an actual "Else" command, since i want the process to just continue forward when the test is not satisfied?

Thanks for your help.


pingpong777

 

[shg]

if range("a1").value2 = 0 then exit for

 

[pingpong777]

thanks!

 

[shg]

You're welcome.