Hi guys, I am pretty new to VBA.. I have a loop running in VBA and it runs perfectly as I want it too, HOWEVER, after it runs it seems to still hog the processor and I cannot do anything in excel for a few seconds, (like 5 secs). I think that this may be because there is no instruction for the VBA to end and to hand back to Excel. The End Loop code I have seen on the web seems to be for code to interrupt the loop, whereas I want the loop to run in it's entirety and then stop.
Code:
Sub Entry() for ii =12 to 39 If cells (3,ii)=1 And cells(6,ii)=1 Then Cells (4,ii)=1 If cells (4,ii) = 1 Then cells(6,ii)=0 next ii End Sub
Comment