macro problem, applying to cell one after another

[parapara]

Hi,

Basically I've got this code:

Please Login or Register  to view this content.

Which calls another macro if the cell in D has a value in it, how do I get this code to carry on in sequence for say 100 cells (or any number I specify).

Thanks

[mikerickson]

This is one way.
Selecting cells causes complications, so this only Selects if necessary. I suspect that the macro breakeven could be sped up by removing the selection.

Please Login or Register  to view this content.

[parapara]

Thanks it worked I just had change your line to Cells(i,4).Select to Cells(i,15).Select as it selects a different cell, should have pointed that out though. My shoddy programming it's my first macro but its working.